topic [resolved] tUniqRow component in Talend Studio

[resolved] tUniqRow component

peterko — Tue, 29 Jul 2014 10:03:53 GMT

It is necessary to sort the rows before using components tUniqRow?
Thanks

Re: [resolved] tUniqRow component

Anonymous — Tue, 29 Jul 2014 10:38:45 GMT

Hi,
Are you looking for TalendHelpCenter:tSortRow to sort your input data firstly? More info about your use case will be preferred.
Best regards
Sabrina

Re: [resolved] tUniqRow component

peterko — Tue, 29 Jul 2014 10:51:27 GMT

No, I need only remove duplicates. So just use tUniqRow without prior Sorting?

Re: [resolved] tUniqRow component

Anonymous — Tue, 29 Jul 2014 11:07:30 GMT

Hi,
There is no "sorting" option in tUniqRow.
Could you please elaborate your case with an example with input and expected output values? In that way, we can see if there is any workaround for your prior Sorting requirment.

Best regards
Sabrina

Re: [resolved] tUniqRow component

peterko — Tue, 29 Jul 2014 11:25:32 GMT

Hello,
I just need to remove duplicate rows. But I saw the tutorial was done and sorting. I wondered if sorting has any effect on removing duplicates. I'm interested in the case of input data already sorted, if then finding duplicates will be faster.
Otherwise, I not need sorted data, only deduplicated.
Thank you.

Re: [resolved] tUniqRow component

Anonymous — Wed, 30 Jul 2014 09:17:35 GMT

Hi,
The job design(tSortRow-->tUniqRow) mainly depends on your input and expected output value not performance.
As a matter of fact, tSortRow is cache component consuming two much memory.

Best regards
Sabrina