Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create a table in Qlik Sense with multiple columns.
Issue is my source data has a column with value as "part1 | part2 | part3 |".
In my table I want to have part1 in my first column, part2 in second column and part3 in third column, like the value before the first pipe character should be in first column and value between first and second pipe chacater in second column and so on.
Please advice on this, thanks.
One solution :
Source_Table:
load *,subfield(column,'|',1) as part1,subfield(column,'|',1) as part2 ,subfield(column,'|',3) as part3 inline [
column
part1 | part2 | part3 |
]
output:
One solution :
Source_Table:
load *,subfield(column,'|',1) as part1,subfield(column,'|',1) as part2 ,subfield(column,'|',3) as part3 inline [
column
part1 | part2 | part3 |
]
output:
Thank you. This works as expected