I receive a number of different files each with it’s own data structure and a seperate general file with generic information (clientnumber + email adres) for each record in the different files .
How can I create within the datamapper a look up for a clientnumber and enrich the original dataset with the email adress?
looks somthing worth giving a try,I will make a csv file true the workflow to test. unfortunately can’t access the sample datafiles and datamapper mentioned in the topic.
There’s a readme in there that explains the final details. The name of the ODBC source, etc.
However, if you’re doing a lookup on a more massive data set like that, it may be more performant if you can get the lookup table into a proper database rather than leaning on the relatively low power of the Excel/Access/CSV ODBC driver.