topic Re: Inner join using tMap in Talend Studio

Inner join using tMap

Anonymous — Sat, 16 Nov 2024 04:31:49 GMT

Hello All

Am using inner join . which i generated the data, to join, but it is not giving me any matched records, i did set the data to match but not matched any record

Thanks

Manish

Re: Inner join using tMap

TRF — Mon, 30 Sep 2019 16:57:35 GMT

Share something like your tMap and a data sample

Re: Inner join using tMap

Anonymous — Mon, 30 Sep 2019 17:02:20 GMT

Hi Manish,

It could be due to multiple reasons. Most common mistakes could be because of trailing or leading spaces, data could be in Caps in main flow and in small letter in lookup. Could you please ad tLogrow before tMap for both main and lookup to see the results? This could give you a clue.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Inner join using tMap

Anonymous — Mon, 30 Sep 2019 17:04:21 GMT

Thanks nikhil, here is what i did The matching column is integer, and its a number, and i trimmed all the columns in both files

Re: Inner join using tMap

Anonymous — Mon, 30 Sep 2019 17:12:25 GMT

@ksingh

Could you please add some screen shots to understand your jobs better?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Inner join using tMap

Anonymous — Mon, 30 Sep 2019 17:26:03 GMT

@ksingh

Its working fine for me. In case you are using any sequence to generate the numbers, please make sure that you are using different sequence for main and lookup.

If you are using default sequence, it will continue from last execution. Since the lookups will be executed before main, your main flow may not be starting with correct starting number.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Inner join using tMap

Anonymous — Mon, 30 Sep 2019 17:34:44 GMT

Am unable to map for my work files, but if i created a prototype am able to do it. the problem is with the bad data i guess as you told before, there is nothing much, that can be wrong tMap does everything , the work files are not in proper model i think

Re: Inner join using tMap

Anonymous — Mon, 30 Sep 2019 17:36:52 GMT

Hi,

It could be due to the data in your files. Add tLogrow and print the data to see the difference in your work file for both main and lookup flows. That is the most easy way to get the clue.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved