Data separator from single column using | character

[Venthan]

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.

[Taoufiq_Zarra · Accepted solution]

@Venthan 

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:

[Venthan]

Thank you. This works as expected