Hello! TOS Version: 6.1.1.20 I have a file with 3 keys and 1 attribute, and I need remove duplicates, considering the rule: Key 1 if (Key 1 == 1 || Key 1 == 3 ) then ignore Key 2 else consider Key 2 Key 3 To attribute, I need first value of partition. My steps (is below): 1 - read file; 2 - send to tMap to recover the list columns that I need; 3 - send one output(with a filter "Key 1 == 1 || Key 1 == 3") to a tUniqRow considering Key 1 and Key 3, and other output(with filter "Key 1 != 1 && Key 1 != 3") to tUniqRow considering Key 1, Key 2 and Key 3 4 - I tried use tUnite to union flows, but before link a one output(from tUniqRow) I can't join the other output(from other tUniqRow)
How do that??
Example of my file: Key 1|Key 2|Key 3|val1 1|2|3|10 1|3|3|10 2|2|3|10 2|3|3|10 3|1|3|10 3|2|3|10 3|3|3|10 3|4|3|10
Output that I need: Key 1|Key 2|Key 3|val1 1|2|3|10 2|2|3|10 2|3|3|10 3|1|3|10
This is not an union. You simply have ONE key (Key 1) and all others are actually not keys in this use case. Use a tAggregateRow and use Key 1 as group column and for the others choose "first".
Good morning people.
Sorry jlolling, but the line 2 and line 3 have the same value for the key 1. an aggregation to the rows where the key 1 is equal to 1 and 3 really is correct, but my problem is to unite the lines that hold the key 1 equal to 2 with the result of aggregation.
