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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tUniqRow not working at all

Hello,

 

I output some row into a file, but I encountered 2 issues

 

- if I uncheck the "append" checkbox in the tFileOutputDelimited, then the file disappears a couple of seconds after the job started, I find no errors in the log

 

- tUniqRow does not filter anything, I try to have it avoid duplicate values for the 'name' column, but it does not work, I have a lot of duplicates in the file (even if I

first delete  it)

 

regards

 

0683p000009M6Nf.png

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Can you show your complete job? I think I can see why this might be a problem. You have what looks like an iterator link joining to your "new products" DB component. What this will do is cause the components following this to process completely before the next iteration. This will cause your file to be created and overwritten for every iteration and will also cause your tUniqRow to ignore data from previous iterations. 

Anonymous
Not applicable
Author

oh, ok

 

the issue is that if I dont use iterate, the lookup in tmap has no values on other tables

 

anyway, I'll remove the duplicates in excel

 

thanks for your help