Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
cimxfang
New 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

Re: remove duplicated rows

Since, This is the only row which is duplicated

6jenny337F

 

Qlik will remove automatically, How are you getting?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)