Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ;
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 ;