topic How to make numbers from a range in QlikView

How to make numbers from a range

marcel_olmo — Thu, 15 Feb 2018 18:04:03 GMT

Hi guys,

I have a table like this :

Code

08000-08042

08060

08061

And I'd like to get this result :

Code

08000

08001

08002

08003

...

08042

08060

08061

How could I get that?

Regards, Marcel.

sunny_talwar — Thu, 15 Feb 2018 18:13:52 GMT

Try this

Table:

LOAD *,

Start + IterNo() - 1 as NewCode

While Start + IterNo() - 1 <= End;

LOAD Code,

SubField(Code&'-', '-', 1) as Start,

SubField('-' & Code, '-', -1) as End;

LOAD * INLINE [

Code

08000-08042

08060

08061

];