Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
flames
Contributor III
Contributor III

Unique Row based all columns

I have a table similar to the below one, i am trying to get rid of duplicate values based on entire row.

for example, i need either row 2 or 3, but not both... also for 3 and 4, and 5,6.

How to work with Distinct function in this situation ? 

to get distinct row based on all columns, Thanks in advance.

Appreciate your help.

 

ROW.NOIDORDERVERSIONNUMBER_INNUMBER_OUT
1QHY78G7310011E5T71350024960
2QHY78G8701541E5T71350025618
3QHY78G8701541E5T71350025618
4QHY78G6703551E5T71350024590
5QHY78G6703551E5T71350024590
6QHY78G4831061E5T71350024590
7QHY78G4831061E5T71350024590
8QHY78GOK1E5T71350024590
Labels (3)
1 Solution

Accepted Solutions
zzyjordan
Creator II
Creator II

Hi, Peekay

Here you go

 

Untitled.jpgHope this make sense.

ZZ

View solution in original post

4 Replies
zzyjordan
Creator II
Creator II

Hi, Peekay

Please find my solution below

 

Untitled.jpgHope this helps

ZZ

flames
Contributor III
Contributor III
Author

Hi ZZ,

it worked. Thanks.

Now have a different issue. 

 

if there is an additional column, and values are different in it, how to choose only one row ??

let me take an example...

in the below example, for each 2 similar rows, there is a difference in one column (highlighted in red)

i want to get only one of those values. either max or min of VALUE , some logic like that.

appreciate if you could help, Thanks in advance.

 

ROW.NOIDORDERVERSIONNUMBER_INNUMBER_OUTVALUECODEZIP
1QHY78G7310011E5T7135002496010CCBY96
2QHY78G8701541E5T7135002561829ABA23
3QHY78G8701541E5T7135002561830ABA23
4QHY78G6703551E5T7135002459029CDB1E
5QHY78G6703551E5T7135002459029XYB1E
6QHY78G4831061E5T7135002459012BZAZ45
7QHY78G4831061E5T7135002459012BZXY36
8QHY78GOK1E5T7135002459010CCAX78
zzyjordan
Creator II
Creator II

Hi, Peekay

Here you go

 

Untitled.jpgHope this make sense.

ZZ

flames
Contributor III
Contributor III
Author

Thank you ZZ, It worked 🙂 🙂