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]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

@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