Нow to create a line list of numbers?

[vtatarnikov]

Sorry for the stupid question..

Нow to create a line list of numbers from 5 to 10 in increments of 1, for example?

Is there a simple function list(5,10,1)=(5,6,7,8,9,10)?

[avinashelite]

use autogenerate function

[#3]

Hi,

use this  =ValueLoop(5,10,1)

[#4]

Hi,

below should work for you, added the loop in to the weighting too so the order is as generated

Concat(ValueLoop(5,10,1),',',ValueLoop(5,10,1))

Joe

[vtatarnikov]

autogenerate create the column.

I am used concat() for convert to string, but column(1,2,3,4,5,6,7,8,9,10,11)=string(1,10,11,2,3,4....)

how to sort in concat()?

[vtatarnikov]

ValueLoop() not a script function

[#7]

Didn't realise you wanted this in the script, but concat has a weight sorting parameter so you can use that to sort

[avinashelite]

Hi ,

What's your exact requirement ? need to generate the columns and sort rite ?

Load 5+RecNo() as num

AutoGenerate(5);

This will do...or do you need to link this with the filed and use for sorting ?? if so use dual() function and assign the number  for it

[manojkulkarni]

set vMax = 10;

set vStart = 5;

set vFreq=1;

Load ($(vStart)-1)+RecNo() as num

AutoGenerate($(vMax)-($(vStart)-1));

[vtatarnikov]