Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have a table as Follows:
DimensionCode | To | From |
1A | 1 | 3 |
1B | 6 | 8 |
and i want the output as
DimensionCode | To | From | Range |
1A | 1 | 3 | 1 |
1A | 1 | 3 | 2 |
1A | 1 | 3 | 3 |
1B | 6 | 8 | 6 |
1B | 6 | 8 | 7 |
1B | 6 | 8 | 8 |
Something like this:
Result:
load DimensionCode, To, From, To + iterno() -1 as Range
from ...somewhere...
while To + iterno() -1 <= From;
Something like this:
Result:
load DimensionCode, To, From, To + iterno() -1 as Range
from ...somewhere...
while To + iterno() -1 <= From;