topic Re: Which component to use union flows? in Talend Studio

Which component to use union flows?

Anonymous — Fri, 06 May 2016 23:00:40 GMT

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

Thanks folks!

Re: Which component to use union flows?

Anonymous — Sat, 07 May 2016 09:47:39 GMT

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".

Re: Which component to use union flows?

Anonymous — Wed, 15 Jun 2016 14:03:58 GMT

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.

Can you see another solution?

Thank you.