topic Re: tmap lookup problem in Talend Studio

tmap lookup problem

husibilski — Sat, 16 Nov 2024 09:20:58 GMT

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

Re: tmap lookup problem

TRF — Wed, 30 Aug 2017 20:26:35 GMT

Hi,

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

Are you sure the letters are capitalized for both input?

Re: tmap lookup problem

Anonymous — Thu, 31 Aug 2017 02:12:16 GMT

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

Re: tmap lookup problem

husibilski — Thu, 31 Aug 2017 11:58:34 GMT

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

Re: tmap lookup problem

TRF — Thu, 31 Aug 2017 12:08:27 GMT

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

Re: tmap lookup problem

husibilski — Thu, 31 Aug 2017 20:37:13 GMT

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

Re: tmap lookup problem

TRF — Thu, 31 Aug 2017 21:19:46 GMT

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

Re: tmap lookup problem

husibilski — Sat, 02 Sep 2017 14:33:23 GMT

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

Re: tmap lookup problem

TRF — Sat, 02 Sep 2017 21:29:59 GMT

As suggested in my 1st reply!