topic Re: How to split the values into a column in QlikView

How to split the values into a column

0li5a3a — Sat, 16 Nov 2024 03:52:32 GMT

Hi there,

I have a qvd where I want to split the values of one column, the find below the format of the table.

Table:

id,name,price

1, Jon, 200

2, Atilla,400

3, Mario,600

4,Ronaldo,800

5,Pele,1200

6, Ronaldinho,1800

I want to create a table which needs to look like this:

Table:

id,name,price

1, Jon, 200

2, Atilla,400

3, Mario,600

4,Ronaldo,800

5,Pele,600

5,Pele,600

6, Ronaldinho,800

6, Ronaldinho,800

Is this possible in qlikview ?

Thanks in advance Const!

Re: How to split the values into a column

sunny_talwar — Fri, 12 Apr 2019 12:16:46 GMT

What is the logic here? Some of the rows got split, but others did not?