[resolved] tunit and merging Excel files

[Anonymous]

I have to merge an excel file and the Excel output of tmap.
Excel file has two lines and tmap output has 93411 rows but the output of tunit has only 7708 rows and no error  message.
what is wrong ?
thanks for your tips

[Anonymous]

Hi,
Are your outputs common schema? Could you please also show us your tUnite component schema setting screenshot?
Best regards
Sabrina 

[Anonymous]

Hi,
Have you checked the scenario @ https://help.talend.com/search/all?query=tUnite
Your output from tMap is not matching using Key columns..
Vaibhav

[Anonymous]

It seems that the output of tunite is OK but the numbers from the output of tmap (it is the number of the main)  are wrong.
I try to reproduce with a small set of datas

[Anonymous]

Hi  jmreymond,

Any update for your issue?

Best regards
Sabrina

[Anonymous]

Actually, no time to set the POC but with the screenshot, clearly the output of tmap is wrong. It is the number of lines of the main table of the tmap instead the number of lines after processing

[Anonymous]

You have the left outer join inside tMap... change it to inner join for appropriate tables...
Vaibhav

[Anonymous]

Sorry but all is OK, only the count of the tMap output is wrong. It should be 7706 instead 93411.
tunit adds 2 rows and 7706 rows (instead 93411 displayed) and produce 7708 rows: it is OK

[Anonymous]

Hi jmreymond,
Can we consider your issue as resolved?
Best regards
Sabrina

[Anonymous]

numbers are wrong but the output is correct. It should be a great feature to have good numbers