This content has been marked as final. Show 5 replies
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|
The script should produce such result:
I have initially authored such script:
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),
However; it seems $(b) is not passed. Just error and stops execution.
I would appreciate for any help on this script.