Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
cimxfang
Contributor
Contributor

remove duplicated rows

Hi guys

Is Load distinct fields the best way to remove duplicated rows in qlik sense. Let us say we have the data below and I would like every row is unique.

Can I use Load distinct id, name ,number ,sex from table to remove duplicated row

idnamenumbersex
1nick1111M
1nick111m
2jenny333F
3jenny334F
4jenny335F
5jenny336F
6jenny337F
7jenny338F
8jenny339F
6jenny337F
1 Reply
Anil_Babu_Samineni

Since, This is the only row which is duplicated

6jenny337F

 

Qlik will remove automatically, How are you getting?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful