Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
use autogenerate function
Hi,
use this =ValueLoop(5,10,1)
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
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()?
ValueLoop() not a script function
Didn't realise you wanted this in the script, but concat has a weight sorting parameter so you can use that to sort
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
set vMax = 10;
set vStart = 5;
set vFreq=1;
Load ($(vStart)-1)+RecNo() as num
AutoGenerate($(vMax)-($(vStart)-1));