Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
];
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
];
Thanks!!