Discussion Board for collaboration related to QlikView App Development.
How to split data into multiple columns based on condition?
Apple : Banana
Orange : Banana
Apple - Banana -Milk
Apple - Banana -Milk - Coffee
Orange : Banana - Tea
Banana -Milk -Coffee
Banana - Tea
subfield(A,':',1) as B
Subfield(A,':',2) as C
Thanks for u r replay,but the out put is not showing some records like with '-'
if(index(A,':')>0,subfield(A,':',1) ,subfield(A,'-',1) ) as B,
if(index(A,':')>0,subfield(A,':',2) ,subfield(A,'-',2) ) as C,
In your Example you're using different separators, is that so?