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

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

Anonymous — Fri, 21 Oct 2011 07:04:26 GMT

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!

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

Fri, 21 Oct 2011 07:28:00 GMT

Hi,

You can Subfiled function.

eg:

subfield(S, ';' ,2)

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

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

Fri, 21 Oct 2011 08:54:05 GMT

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.

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

Anonymous — Wed, 26 Oct 2011 07:54:24 GMT

Thanks! Very helpful!