topic Data separator from single column using | character in App Development

Data separator from single column using | character

Venthan — Mon, 20 Dec 2021 21:08:46 GMT

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.

Re: Data separator from single column using | character

Taoufiq_Zarra — Mon, 21 Sep 2020 09:07:35 GMT

@Venthan

One solution :

output:

Re: Data separator from single column using | character

Venthan — Tue, 22 Sep 2020 08:29:32 GMT

Thank you. This works as expected