Autogenerate records based on fields

[#1]

I'm trying to autogenerate records based on 2 fields. Start Operation and End Operation. e.g. 10 -50. I need to generate records by increments of 10. Therefore, i would have 10, 20, 30 , 40, 50 for this particular record. It also needs to be dynamic for each record since the start and end operation will vary by record. Any ideas?

[swuehl · Accepted solution]

Maybe like this?

LOAD Value,

StartOperation+(iterno()-1)*10 as Operation

while StartOperation+(iterno()-1)*10<=EndOperation;

LOAD * INLINE [

Value, StartOperation, EndOperation

10, 10, 50

];

[#3]

Thanks!!