Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
su_pyae
Creator
Creator

Unique values using the script

Hi everyone, 

I am trying to get distinct values from a table.  

ID Kind Type
1 CFF ABC
1 CFF ABC
1 CFF ABC
2 EMI IRL
2 EMI IRL
3 CFF ABC
4 CCS SEV
4 CCS SEV
5 DEP -
6 FX -
6 FX -

 

I am trying to get distinct value of ID, Kind and Type like in this following table:

ID Kind Type
1 CFF ABC
2 EMI IRL
3 CFF ABC
4 CCS SEV
5 DEP -
6 FX -

 

Thank you for your help in advance!

2 Replies
anat
Master
Master

use Rowno() in script and call same in table and hide this field

su_pyae
Creator
Creator
Author

Thank you for the suggestion but I am not clear what you want me to do. 

I need to get the modified table in the script without using frontend tools since I still need to work on it for other tasks.