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

How can I subdivide a string like "level1 | level2 | level3" into 3 Datafields

Hi! I try to analyse our data from our ticketsystem. There is a field called section where users can choose the concerning topic of the ticket via a treeview. The database shows the 3 levels of this treeview as one string like 'level1 | level2 | level3'. How can I subdivide this string via script into three fields for each level? Thx!

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

You can Subfiled function.

eg:

subfield(S, ';' ,2)

returns 'cde' if S is 'abc;cde;efg'

View solution in original post

3 Replies
Not applicable
Author

Hi,

You can Subfiled function.

eg:

subfield(S, ';' ,2)

returns 'cde' if S is 'abc;cde;efg'

Not applicable
Author

Try ths in your script.

Temp:

Load * Inline [

LinkValue,

level1 | level2 | level3

];

LinkSplit:

Load LinkValue,subfield(LinkValue,'|') as LinkSplit Resident Temp;

Drop table Temp;

Regards,

Kiran.

Anonymous
Not applicable
Author

Thanks! Very helpful!