How to fetch value of a column corresponding to a row fetched from Qliksense

[vijaykamani]

Hello Professionals,

i am try to extract vales from Column, 

i have a column "program_list" in this column we have values {AB},{BC},{CD} like this

i want to show individual like 

if 

program list              Advanced         Business       Card

{AB}                                 1                           0                     0

{AB,BC}                           1                          1                      0

{AB,BC,CD}                     1                          1                      1

{AB,BC,CD}                     0                          1                      1

like above i need to show, please help me to solve 

Many thanks,

Vijay

[MayilVahanan]

Hi

Try like below

LOAD *,

if(SubStringCount(programlist, 'AB'), 1, 0) as Advanced,

if(SubStringCount(programlist, 'BC'), 1, 0) as Business,

if(SubStringCount(programlist, 'CD'), 1, 0) as Card INLINE [
programlist

{AB}

"{AB,BC}"

"{AB,BC,CD}"

];