topic Re: [resolved] tunit and merging Excel files in Talend Studio

[resolved] tunit and merging Excel files

Anonymous — Tue, 02 Dec 2014 19:16:18 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Wed, 03 Dec 2014 03:00:47 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Wed, 03 Dec 2014 06:50:12 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Wed, 03 Dec 2014 10:43:10 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Thu, 04 Dec 2014 08:50:09 GMT

Hi jmreymond,

Any update for your issue?

Best regards
Sabrina

Re: [resolved] tunit and merging Excel files

Anonymous — Thu, 04 Dec 2014 09:04:00 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Thu, 04 Dec 2014 09:43:00 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Thu, 04 Dec 2014 13:26:05 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Fri, 05 Dec 2014 07:58:27 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Fri, 05 Dec 2014 08:20:23 GMT

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

Re: [resolved] tunit and merging Excel files

Anonymous — Fri, 05 Dec 2014 08:38:29 GMT

Hi,
Could you please re-create a new job and replicate your current work flow to see if it is OK with you? What's your build version?
Best regards
Sabrina

Re: [resolved] tunit and merging Excel files

Anonymous — Fri, 05 Dec 2014 10:19:55 GMT

OK, I create a new and very small job.
Input, two excel files:
1. /tmp/header.xls with only one line : 1
2. /tmp/body.xls with 20 lines starting from 50 to 69
tmap is a simple copy of body and has two identical output: one to tunite et another one to tlogrow
first run: without filters to tmap and the output of tmap for tunit displays 20 rows , it is OK
second run: filter with row1.cpt < 55, so I have 5 lines (50-54) and tmap displays 20 lines: it is wrong but tunit displays output of 6 lines, it is correct. Note it is OK for tlogrow

Re: [resolved] tunit and merging Excel files

Anonymous — Fri, 05 Dec 2014 10:31:12 GMT

Hi,
On which official version did you get that ?

Best regards
Sabrina

Re: [resolved] tunit and merging Excel files

Anonymous — Fri, 05 Dec 2014 10:38:11 GMT

sorry.
"Talend Open Studio for Data Integration"
Version: 5.5.1
Build id: r118616-20140617-1110

Re: [resolved] tunit and merging Excel files

Anonymous — Mon, 08 Dec 2014 07:24:08 GMT

Hi,
We got the same result on Version: 5.5.1. Could you please create a workItem Jira issue of DI project on Talend Bug Tracker?
Best regards
Sabrina

Re: [resolved] tunit and merging Excel files

Anonymous — Thu, 16 Apr 2015 10:26:56 GMT

Hi,
Here is the jira link: https://jira.talendforge.org/browse/TDI-31601.
Best regards
Sabrina