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: 
Not applicable

Splitting column values with wildmatch condition.

I have a column called Country with values as below

Country

US,MX,CH

CH

MX,BR,IND,

SA,NA,US

Using wild match How can i make these column values as individual columns like US,MX,CH,BR,IND,SA,NA

13 Replies
Not applicable
Author

I tried this.

subfield(subfield(Subfield([Country],','),';'),' ') as [Country]

sunny_talwar

Not sure what you mean, but may be this:

Table:

LOAD Trim(SubField(SubField(Country, ','), ';')) as Country;

LOAD * Inline [

Country

US,MX,CH

CH

MX,BR,IND

SA;NA;US

] (delimiter is |);

Not applicable
Author

thank you very much.

Not applicable
Author

Is the below doable ?Thank you.

I have a column called States.

STATES

AL

GA

MI

SFO,SAN,WD,MI

MD;SAN

FL


Note:I have , and ; and space within the values.SFO,SAN,WD,MI has ',' in between where as MD;SAN has ';' in between and also

before GA there is a space.


How can I group this column values as below.SFO and SAN should fall under CAL.So,here new row called CAL gets created for SFO and SAN.


STATES

AL

GA

MI

WD

MD

FL

CAL