5 Replies Latest reply: Mar 31, 2014 11:41 AM by Atsushi Saijo RSS

    Autogenerate inside Loop

    Atsushi Saijo

      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 NumberMaximum Number of Labels
      A2
      B5
      C3

       

      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