Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load
Item,
Lot,
Location,
1 as NewQuantity
From ...
While IterNo() <= Quantity;
Load
Item,
Lot,
Location,
1 as NewQuantity
From ...
While IterNo() <= Quantity;