Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
You can Subfiled function.
eg:
subfield(S, ';' ,2) | returns 'cde' if S is 'abc;cde;efg' |
Hi,
You can Subfiled function.
eg:
subfield(S, ';' ,2) | returns 'cde' if S is 'abc;cde;efg' |
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.
Thanks! Very helpful!