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
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.
I attached a hardcopy with the tmap.
Type of both variables is string. Same code page.
What is wrong. I am looking for help.
Solved! Go to Solution.
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.
Tanks to all
the problem was
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