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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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