Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

How to remove duplicate records

I have table like  SID, SNAME,

SID, SNAME, SMARKS

1, Hari, 30

2, Sourav, 55

3, Sachin, 75

3, Sachin, 75

4. Mahesh, 65:

I got ID (3) in multiple times. i want remove that duplicate values.

3 Replies
petter
Partner - Champion III
Partner - Champion III

SID seems to be a unique identifier that could be used to check against to identify duplicates.

LOAD

  *

FROM

  [.....]

WHERE

  Not(Exists(SID));

jomar_ebonite
Partner - Contributor III
Partner - Contributor III

Hi,

Try to use distinct in Load Script.

LOAD Distinct
*

FROM

thannila
Creator
Creator

Try this Below Code:

Data:

load * Inline

[

SID, SNAME, SMARKS

1, Hari, 30

2, Sourav, 55

3, Sachin, 75

3, Sachin, 75

4, Mahesh, 65

];

RIGHT JOIN(Data)

Data1:

load distinct SID,SNAME

resident Data;