topic Tmap and multiple inputs in Talend Studio

Tmap and multiple inputs

Anonymous — Wed, 10 Jul 2013 09:32:59 GMT

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

Re: Tmap and multiple inputs

Anonymous — Wed, 10 Jul 2013 09:40:22 GMT

Hi,
How did you set your tMap? Could you give us the tMap editor screenshot? You have two input source, one is Main, and the other is LookUp. What is your expected result? Inner join?unite?
Best regards
Sabrina

Re: Tmap and multiple inputs

Anonymous — Wed, 10 Jul 2013 09:55:12 GMT

here is the tmap, i just need that the 1st input go to an output and the second to another.
I can't change the Join model, is it the problem?

Re: Tmap and multiple inputs

Anonymous — Wed, 10 Jul 2013 10:11:34 GMT

Hi,

here is the tmap, i just need that the 1st input go to an output and the second to another.

If there is no operation of join,or other operation. Why don't you use tfileinputdelimited-->tfileoutputdelimited instead.

I can't change the Join model, is it the problem?

The join module won't work until there is a condition (for example row1.id=row2.id).
Best regards
Sabrina

Re: Tmap and multiple inputs

Anonymous — Wed, 10 Jul 2013 10:20:37 GMT

Thank you sabrina, i think i was going on the wrong way.

Re: Tmap and multiple inputs

Anonymous — Wed, 10 Jul 2013 10:32:23 GMT

Hi,
It's OK. Don't hesitate to post your issue on forum.
In addition, here are some articles about tMap, tMap operation and tMap Job example. Hope it will be useful for studying tMap component.
Best regards
Sabrina

Re: Tmap and multiple inputs

Anonymous — Tue, 24 Feb 2015 16:03:04 GMT

I am trying to do a reconciliation for the Oracle DB v/s data loaded through ETL in Mongo but my Tmap is not accepting 2 inputs. Can you please share some ideas?

Re: Tmap and multiple inputs

Anonymous — Tue, 24 Feb 2015 16:04:45 GMT

I also want do some versioning for the Talend jobs. What is the best way to do it?

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 08:03:40 GMT

Hi.

I have question.

My input used is tDbInput and tFileDelimited -> tmap -> 2 tFileDelimited files.

My inputs have both 9rows and here is my problem, if i just want to put in my output the single column of my 1st input, it should print 9results but here, it is printing 81 (9*9) results.

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 08:16:06 GMT

@vuthuy95
It is normal, you are doing join on tMap, each row from main flow will join all rows from lookup table. Can you describe your requirement with details? So that I can give you more accurate answers or solutions.

Regards
Shong

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 08:21:05 GMT

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

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 08:25:07 GMT

@shong

This is the job I'm doing

talend.jpg

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 08:31:36 GMT

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

Re: Tmap and multiple inputs

manodwhb — Wed, 27 May 2020 08:34:26 GMT

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

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 09:01:34 GMT

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

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 09:45:20 GMT

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-p/21572

Regards

Shong

Re: Tmap and multiple inputs

Anonymous — Wed, 27 May 2020 09:54:08 GMT

@shong
Thank you. I will try it now.