Discussion Board for collaboration related to QlikView Deployment.
I'm facing a trouble trying to generate new rows for a content between two values. I have the following simple example:
And I would like to obtain the following result
Does anybody know how can I get this?
Thank you very much
Go to Solution.
May be this
PREFIX & Num(Start + IterNo()-1, '000') as RESULT
While Start + IterNo()-1 <= End;
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
Generating Missing Data In QlikView