Discussion Board for collaboration on QlikView Scripting.
I would like to change my table.
My source table looks like this.
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?
While IterNo() <= number;
View solution in original post
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.