Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kat300895
Contributor
Contributor

Removal of duplicates

Hi, I have scenario where there are 3 fields

date,id,case

1/20/1995,1,yes

1/20/1995,1,no

1/30/1995,2,yes

In the above scenario date and ID are same for first two records but case is different and I want these two records to show as a single record(with 'no' case) as below  output

date,id,case

1/20/1995,1,no

1/30/1995,yes.

Labels (1)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

if you just want it on the front end 

you can create a table 

with id and date as dimensions 

and minstring(case) as expression 

if you want to remove the records in the script than 

it should look like this 

 

load date,

          id,

        minstring(case) as case 

group by date,id ;

Load date,id,case 

from Table ;

View solution in original post

1 Reply
lironbaram
Partner - Master III
Partner - Master III

hi 

if you just want it on the front end 

you can create a table 

with id and date as dimensions 

and minstring(case) as expression 

if you want to remove the records in the script than 

it should look like this 

 

load date,

          id,

        minstring(case) as case 

group by date,id ;

Load date,id,case 

from Table ;