Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dreweezy
Partner - Creator II
Partner - Creator II

parsing out string from a field into multiple field depending on the string it matches

Hello all,

I am trying to parse out specific values from a long text depending on what the users input from our GUI/tool. Our data is being stored in one field/column and I hope to parse out specific values/texts from that field and place a "X" or a "1" to denote that those texts have been found in their respective new columns.

Example - 

Column 1 (String) - "Finance, Accounting, Marketing, IST, IT, Dance,  Business"

Now I have 3 columns that will mark a "X" or a "1" to denote that those values were found in column1 where the string resides. In this case, I will have a "X" marked for Finance, Dance, and Accounting columns.

Image attached to ease the confusion. 

Thank you.

 

Labels (3)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Use index function in your load script
E.g.
If (index(Column1,'Finance')>0, 1,0) as Finance,
If (index(Column1,'Accountin')>0, 1,0) as Accounting

View solution in original post

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

Use index function in your load script
E.g.
If (index(Column1,'Finance')>0, 1,0) as Finance,
If (index(Column1,'Accountin')>0, 1,0) as Accounting