topic Duplicate rows based on field quantity in QlikView

Duplicate rows based on field quantity

Anonymous — Thu, 22 Feb 2018 10:09:12 GMT

Dear all,

I have a table as shown below.

I am trying to achieve the breakdown of quantity to 1 unit per row.

How do I go about using a 'for loop' to duplicate the records? Or suggest any better methods.

The above is just a simple example. There could be multiple fields.

Thanks in advance!

sunny_talwar — Thu, 22 Feb 2018 10:11:25 GMT

May using While loop...

LOAD Code,

1 as Qty

FROM ...

While IterNo() <= Qty;

sunny_talwar — Thu, 22 Feb 2018 10:13:52 GMT

Here is a sample script using Inline load

LOAD RowNo() as RowNum,

Code,

1 as Qty

While IterNo() <= Qty;

LOAD * INLINE [

Code, Qty

A001, 1

A002, 1

B001, 2

B002, 3

];

tamilarasu — Thu, 22 Feb 2018 10:25:30 GMT

I think both of you are working in the same/similar project/office as you both have same question.