topic Re: transform table in QlikView

transform table

qlikviewalex — Tue, 08 May 2018 13:58:27 GMT

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.

Is this possible?

Thanks

Alex

sunny_talwar — Tue, 08 May 2018 14:01:26 GMT

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 — Tue, 08 May 2018 14:02:18 GMT

Why 3 is not there in the outcome?

sunny_talwar — Tue, 08 May 2018 14:04:16 GMT

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 — Tue, 08 May 2018 14:05:42 GMT

Haha, You made it

qlikviewalex — Tue, 08 May 2018 14:05:47 GMT

Thanks, it works well.