Generate Table based on column value

[qlikviewaf]

Hello everyone.

I have a table structure as the one below "current table" - i would like to generate a table starting from the current one, where the row by Item/Lot/Location is repeated many times as the quantity value. 

There's any way on qlikview to do this?

Thank you

[hic · Accepted solution]

Load
Item,
Lot,
Location,
1 as NewQuantity
From ...
While IterNo() <= Quantity;