I'm a Talend and Java newbie and using TOS DI 6.3.
My problem I need a lookup in tmap. Both input files have a value like
800F4F3B-CFE1-42C1-9CEA-675512810488
Thies a offer id form MS Azure. When loading the CSV files to Excel, I can find the value in both files. But when do this in Talend tmap, it doesn’t work, the value will not be found.
Before tMap, I would suggest you to use a tLogrow to print the value on the console to see the real value are read from the source file, so you can check if they are really identical.
Before tMap, I would suggest you to use a tLogrow to print the value on the console to see the real value are read from the source file, so you can check if they are really identical.
I have loaded the files from Microsoft CSP Partner Center into MySQL. Joined them in a query. It works fine. I think TOS can't handle the files. It is better for our solution to change to Microsoft Intergration Services.
in first file the key value was in uppercase in the second in lowercase. Excel found the searched key, because the search was case insensitive. Sorry, but my English is very poor
