Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

Thanks Sabrina!