Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
id | name | number | sex |
1 | nick | 1111 | M |
1 | nick | 111 | m |
2 | jenny | 333 | F |
3 | jenny | 334 | F |
4 | jenny | 335 | F |
5 | jenny | 336 | F |
6 | jenny | 337 | F |
7 | jenny | 338 | F |
8 | jenny | 339 | F |
6 | jenny | 337 | F |
Since, This is the only row which is duplicated
6 | jenny | 337 | F |
Qlik will remove automatically, How are you getting?