topic Re: Autogenerate inside Loop in QlikView

Autogenerate inside Loop

atsushi_saijo — Mon, 31 Mar 2014 15:27:59 GMT

Dear Gurus,

I stumbled in a requirement where I must autogenerate NoOfRow() inside loop.

Specifically, this application is used as a source file for labels. The user put an excel file, where [a.] part number; [b.] Maximum number of labels to print.

Part Number	Maximum Number of Labels
A	2
B	5
C	3

The script should produce such result:

A 1

A 2

B 1

B 2

...

B 5

C 1

C 2

C 3

[Attempted Script]

I have initially authored such script:

//Initial Load

T1: Load [Part Number] as P#, [Maximum Number of Labels] as Max from (Source Excel);

//Getting maximum number of rows in the source file

Let noRows = NoOfRows('T1')

//define loop condition

for i=0 to $(noRows)-1

Let a = peek ('P#', $(i), 'T1');

Let b = peek ('Max', $(i), 'T1');

//Generate serialised number

T2: Load RowNo() as Serial Autogenerate $(b),

Next;

[Issue]

However; it seems $(b) is not passed. Just error and stops execution.

I would appreciate for any help on this script.

Atsushi

Re: Autogenerate inside Loop

Gysbert_Wassenaar — Mon, 31 Mar 2014 15:33:13 GMT

Try using the while keyword:

LOAD *, iterno() as RecNo

while IterNo() <= [Maximum Number of Labels]

From ...somewhere...;

Re: Autogenerate inside Loop

atsushi_saijo — Mon, 31 Mar 2014 15:34:19 GMT

Thanks, I am trying now.

Re: Autogenerate inside Loop

atsushi_saijo — Mon, 31 Mar 2014 15:39:01 GMT

Excellent it is working. IterNo() is used as serial, and while ..... close was used as condition. I appreciate for your fast and elegant resolution.

Re: Autogenerate inside Loop

MK_QSL — Mon, 31 Mar 2014 15:39:18 GMT

Temp:

Load * Inline

[

Part Number, Label

A, 2

B, 5

C, 3

];

Load

[Part Number],

IterNo() as NO

Resident Temp

While IterNo() <= Label;

Drop Table Temp;

Re: Autogenerate inside Loop

atsushi_saijo — Mon, 31 Mar 2014 15:41:32 GMT

I appreciate for your support too. Your solution is working. I deeply appreciate for your fast resolution. Atsushi