AlesD Posted November 2, 2012 Posted November 2, 2012 Hi, I would like to import records from cvs file, problem is I want to update matching records only but my record in cvs has another string appended to it which is unfortunately changing. Is it possible make calculation before record match? example: FM record is joseph and in cvs joseph_something I know I can edit cvs before I'll import to FM but this isn't what I want.
comment Posted November 2, 2012 Posted November 2, 2012 Is it possible make calculation before record match? No, not at the source side anyway. Why don't you import into a temp table first, then import from there - using a calculation field in the temp table as the match? 1
Recommended Posts
This topic is 4405 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now