transform table

[qlikviewalex]

Hello,

I would like to change my table.

My source table looks like this.

Directory;

LOAD No,

     number,

     price

FROM

Table1;

No	number	price
1	2	2,5
2	3	2,4

I want to reshape the table using the "Number" field. The column specifies the number of new rows.

The new table should then look like this.

No	price
1	2,5
1	2,5
2	2,4
2	2,4
2	2,4

Is this possible?

Thanks

Alex

[sunny_talwar · Accepted solution]

Try this

Directory;

LOAD No,

    number,

    price

FROM Table1

While IterNo() <= number;

or this

Directory;

LOAD No,

    price

FROM Table1

While IterNo() <= number;

[Anil_Babu_Samineni]

Why 3 is not there in the outcome?

[sunny_talwar]

I think qlikviewalex‌ wants to repeat the rows based on the value in the number field. So, No = 2 has number = 3... so it repeats 3 times.

[Anil_Babu_Samineni]

Haha, You made it

[qlikviewalex]

Thanks, it works well.