Six Stars

tmap lookup problem

Hello,

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.

I attached a hardcopy with the tmap.

 

 

Type of both variables is string. Same code page.

 

What is wrong. I am looking for help.

 

Regards

HUS

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Manager

Re: tmap lookup problem

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.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
8 REPLIES
Twelve Stars TRF
Twelve Stars

Re: tmap lookup problem

Hi,

Do you have the problem for all values or just for this one?

Are you sure the letters are capitalized for both input?


TRF
Community Manager

Re: tmap lookup problem

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.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: tmap lookup problem

Hi,

 

the problem is with all values. All variables are in upper case. Using the data in Excel I can find the values in both datasets.

 

regs

Twelve Stars TRF
Twelve Stars

Re: tmap lookup problem

Can you share the properties for the "Daten" tMap output (as you did for "FehlerLookup" output)?


TRF
Six Stars

Re: tmap lookup problem

Hello,

 

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

Twelve Stars TRF
Twelve Stars

Re: tmap lookup problem

Very surprising! Can you share the file or indicate where to go to get it?

TRF
Six Stars

Re: tmap lookup problem

Hello,

 

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

Twelve Stars TRF
Twelve Stars

Re: tmap lookup problem

As suggested in my 1st reply!

TRF