Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm facing a trouble trying to generate new rows for a content between two values. I have the following simple example:
VALUE1 | VALUE2 | NUMBEROFVALUES | PREFIX |
---|---|---|---|
ES001 | ES004 | 4 | ES |
CS002 | CS003 | 2 | CS |
And I would like to obtain the following result
VALUE1 | VALUE2 | NUMBEROFVALUES | RESULT |
---|---|---|---|
ES001 | ES004 | 4 | ES001 |
ES001 | ES004 | 4 | ES002 |
ES001 | ES004 | 4 | ES003 |
ES001 | ES004 | 4 | ES004 |
CS002 | CS003 | 2 | CS002 |
CS002 | CS003 | 2 | CS003 |
Does anybody know how can I get this?
Thank you very much
Kind regards
May be this
Table:
LOAD VALUE1,
VALUE2,
NUMBEROFVALUES,
PREFIX & Num(Start + IterNo()-1, '000') as RESULT
While Start + IterNo()-1 <= End;
LOAD *,
KeepChar(VALUE1, '0123456789') * 1 as Start,
KeepChar(VALUE2, '0123456789') * 1 as End;
LOAD * INLINE [
VALUE1, VALUE2, NUMBEROFVALUES, PREFIX
ES001, ES004, 4, ES
CS002, CS003, 2, CS
];
May be this
Table:
LOAD VALUE1,
VALUE2,
NUMBEROFVALUES,
PREFIX & Num(Start + IterNo()-1, '000') as RESULT
While Start + IterNo()-1 <= End;
LOAD *,
KeepChar(VALUE1, '0123456789') * 1 as Start,
KeepChar(VALUE2, '0123456789') * 1 as End;
LOAD * INLINE [
VALUE1, VALUE2, NUMBEROFVALUES, PREFIX
ES001, ES004, 4, ES
CS002, CS003, 2, CS
];