Inner join using tMap

[Anonymous]

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

[TRF]

Share something like your tMap and a data sample

[Anonymous]

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

[Anonymous]

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

[Anonymous]

@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

[Anonymous]

@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

[Anonymous]

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

[Anonymous]

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