topic Re: [resolved] taggregaterow vs taggregatesortedrow vs tuniqrow in Talend Studio

[resolved] taggregaterow vs taggregatesortedrow vs tuniqrow

Anonymous — Sat, 16 Nov 2024 12:26:44 GMT

Hi,
I'm pulling out unique combinations of fields from a file.
What I'm doing atm is using taggregaterow and grouping on the fields I want to have unique and using no expressions. Seems to work ok.
But I wonder what the difference between aggregatesortedrow and aggregaterow is. And uniqrow needs to work on sorted input as well if I read the docs correctly so what's the deal there?
Br
/fr

Re: [resolved] taggregaterow vs taggregatesortedrow vs tuniqrow

Anonymous — Wed, 18 Jan 2012 03:40:18 GMT

Hi
Here is test data.

id;name;
2;a
2;c
1;b

If you use taggregaterow with setting "group by" id and "first" each row, the output will like this.

2;a
1;b

If you use taggregatesortedrow with the same settings, the output will as follow.

1;b
2;a

If you use tuniqrow, you can not only get the unique row but also the duplicate row.
Regards,
Pedro

Re: [resolved] taggregaterow vs taggregatesortedrow vs tuniqrow

Anonymous — Wed, 18 Jan 2012 09:23:12 GMT

Thanks for the info!
BR
/fr

Re: [resolved] taggregaterow vs taggregatesortedrow vs tuniqrow

Anonymous — Sat, 10 May 2014 10:06:52 GMT

Will tAggregateSortedRow Sort first and then Aggregate it or first Aggregate then sort it?