Discussion board where members can get started with Qlik Sense.
I have below table
And I want to convert above into below table
Thanks in Advance.
is there id value for HOLD also?
What I want to do is . If the id 1 has value booked and order_hold both .
I want to assign a new value as ''HOLD" .
And consider only one row instead of 2.
In a chart May be like if(Index(Aggr(Concat(Status,','),ID),'Booked')>0 And (Index(Aggr(Concat(Status,','),ID),'order_hold')>0,'HOLD')
if you want to do it in the script level, try like below
Left Join(your Table)
Noconcatenate Load *,
if(wildmatch(ConcatenatedStatus,'order_hold'),'Booked')>0,'HOLD') As NewStatus
Resident Your Table
Drop Your Table