4 Replies Latest reply: Aug 17, 2015 3:54 AM by arjun rao RSS

    Is RowNo function skipping first value by default?

    John Blomqvist

      Hi all,

       

      I have the following table:

       

      FullTable:

      LOAD

          Num($(vMin)+ RowNo()-1) as Numbers1

      AutoGenerate

          $(vMax) - $(vMin)+1;

       

      This table generates all possible numbers from 1 to 100.

       

      I've noticed that if I don't insert a -1 after RowNo() function above it starts from number 2.

       

      And I have to do a +1 in order to get the last value.

       

      Is it because RowNo() is by default gives you the next row rather than the first row value?