Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] tunit and merging Excel files

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
0683p000009MBoi.png
Labels (2)
15 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

0683p000009MBos.png 0683p000009MBl6.png
Anonymous
Not applicable
Author

Hi,
On which official version did you get that ?

Best regards
Sabrina
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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