Removal of duplicates

[kat300895]

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.

[lironbaram · Accepted solution]

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 ;