Generate a sequence in rows

[jsanchezh]

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

[m_woolf]

Generating Missing Data In QlikView

[sunny_talwar · Accepted solution]

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

];