Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
RowNo() always starts at 1. If you dont write -1 your min numbers will be died.
slight change to your script..
RowNo() starts from 1
set vMin=0; | |
set vMax=100; |
FullTable:
LOAD
Num($(vMin)+ RowNo()) as Numbers1 | |
AutoGenerate
$(vMax) -$(vMin)+RowNo();
Hi
Have you managed to solve your problem?
Sasi
Hi John,
Please close the thread if you got the solution. Thank you.