Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Directory;
LOAD No,
number,
price
FROM Table1
While IterNo() <= number;
or this
Directory;
LOAD No,
price
FROM Table1
While IterNo() <= number;
Try this
Directory;
LOAD No,
number,
price
FROM Table1
While IterNo() <= number;
or this
Directory;
LOAD No,
price
FROM Table1
While IterNo() <= number;
Why 3 is not there in the outcome?
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.
Haha, You made it
Thanks, it works well.