topic Re: How to split data into multiple columns based on condition? in QlikView

How to split data into multiple columns based on condition?

Anonymous — Tue, 07 Nov 2017 09:28:13 GMT

Hi All,

How to split data into multiple columns based on condition?

Raw data:

Apple : Banana

Orange : Banana

Apple - Banana -Milk

Apple - Banana -Milk - Coffee

Orange : Banana - Tea

Output:

Thanks,

Krishna.

shraddha_g — Tue, 07 Nov 2017 09:35:10 GMT

Try

subfield(A,':',1) as B

Subfield(A,':',2) as C

Anonymous — Tue, 07 Nov 2017 11:13:47 GMT

Hi Shraddha,

Thanks for u r replay,but the out put is not showing some records like with '-'

Thanks,

Krishna

shraddha_g — Tue, 07 Nov 2017 11:27:24 GMT

Try

if(index(A,':')>0,subfield(A,':',1) ,subfield(A,'-',1) ) as B,

if(index(A,':')>0,subfield(A,':',2) ,subfield(A,'-',2) ) as C,

Anonymous — Tue, 07 Nov 2017 11:44:31 GMT

In your Example you're using different separators, is that so?