Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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