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

Split String Function In QlikView

I have a string column in a table with ; as delimiter but number of parts are not fixed it can be 1 or 5 or 100.

Any idea how can I split the string and create separate records from it at load time.

Example:

LOAD ID,

LongString, // LongString have values like "ABC;DEF;HIJ;KLM" OR "XYZ;OPR;LMJ" OR "PPP;SSS"

RESIDENT OldTab:



Thanks

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hello,

Use

LOAD ID, SubField(LongString, ';') AS FieldNameRESIDENT OldTab;


Hope that helps.

View solution in original post

3 Replies
Miguel_Angel_Baeyens

Hello,

Use

LOAD ID, SubField(LongString, ';') AS FieldNameRESIDENT OldTab;


Hope that helps.

Not applicable
Author

Thanks

It worked very well...never knew I could use subfield without field_no parameter.

Karim_Khan
Creator III
Creator III

Very Quick for solution Thanks

KK