Tmap and multiple inputs

[Anonymous]

Hello,
I am facing a problem. Indeed here is my schema:
tfileInputExcell - main -> TMAP -> tLogRow
tfileInputExcell - main ->^^^^
So, it is a simple Tmap component with 2 inputs.
My inputs have both 16rows and here is my problem, if i just want to put in my output the single column of my 1st input, it should print 16results but here, it is printing 256 (16*16) results.
I can clearly see that the tmap is crossing data of each input but it is possible to have 2 different outputs fur each input by using only one tmap? Maybe i should use 1 Tmap for each input?
Thank you in advance

[Anonymous]

My wish is that the output does not multiply by row 2 tables

[Anonymous]

@shong 

This is the job I'm doing

talend.jpg

[Anonymous]

If you don't set any keys between inputs, it always output 81 rows. Can you upload a screenshot of tMap？

[manodwhb]

@vuthuy95 , Yes Agree with @shong  and your tmap is doing cross join because of that you are seeing more records.

[Anonymous]

@shong 
This is my tMap. You can watch it for me

[Anonymous]

For Update, if you need to do inner join or left outer join cross the two inputs, set the join keys, see

I hope this article will help you to understand the join model using tMap.

https://community.talend.com/t5/Design-and-Development/Doing-an-inner-join-using-a-tMap-component/ta...

Regards

Shong

[Anonymous]

@shong 
Thank you. I will try it now.