The Definitive Guide to Data Quality
I have been using the tMap component to map something from a source spreadsheet to another spreadsheet output. I have also used lookup tables (from a database) in order to look up IDs to map to the target.
I have a source spreadsheet with the street types (ave, blvd, rd, etc) and i want it to look up the ID for each street type in the lookup table, and map the ID to the target spreadsheet. The probelm is that my lookup table has 2 columns, one for French and one for English, and my source spreadsheet only has one column for street type, which French and English names mixed in. How do I do a lookup in this case?
When I try to link the street type column in the source spreadsheet with the French and English street type columns in the lookup table, and map the ID out to the target, it doesn't work.