Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
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
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

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

View solution in original post

flames
Contributor III
Contributor III

Thank you ZZ, It worked 🙂 🙂