[resolved] tUnique Row doubt

One Star

[resolved] tUnique Row doubt

Hi I want to know if tUniqRow sends the "First" duplicate row to the Uniques or it is a random selection? If it is a random selection how can I get first duplicate.
ex-
my input is-
ID;Name
1;shruti1
2;dhruv
3;shruti2
output unique records I need are
1;shruti1
2;dhruv

Thanks

Accepted Solutions
Moderator

Re: [resolved] tUnique Row doubt

Hi,
We don't see that there is any duplication in your "Name" column? 
Do you mean 
ID;Name
1;shruti1
2;dhruv
3;shruti1
If so, it will send the "First" duplicate row to the Uniques. 
The output looks like:  1;shruti1
                               2;dhruv
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: [resolved] tUnique Row doubt

Hi,
We don't see that there is any duplication in your "Name" column? 
Do you mean 
ID;Name
1;shruti1
2;dhruv
3;shruti1
If so, it will send the "First" duplicate row to the Uniques. 
The output looks like:  1;shruti1
                               2;dhruv
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] tUnique Row doubt

Thanks Sabrina!