topic Inline Stuff in QlikView

Inline Stuff

marcel_olmo — Wed, 31 Dec 2014 18:05:54 GMT

Hi guys, I have some customer codes to group, and I have one question :

If I have the following inline where '*' means any possible number :

InlineGroups:

LOAD * INLINE [

CustomerCode,CustomerGroup

048**,Group1

049**,Group2

];

How could I expand it to get the following result?

CustomerCode, CustomerGroup

04800,Group1

...

04899,Group1

04900,Group2

...

04999,Group2

Any ideas about how to do this?

Regards, Marcel.

Anonymous — Wed, 31 Dec 2014 18:27:12 GMT

Hello, can you try this?

InlineGroups:

LOAD * INLINE [

CustomerCode,CustomerGroup

048**,Group1

049**,Group2

];

LOAD

num(SubField(CustomerCode, '*',1),'000') & num(IterNo()-1,'00') as CustomerCode,

CustomerGroup

Resident InlineGroups

While IterNo() <= 99

Elena

rwunderlich — Wed, 31 Dec 2014 18:33:49 GMT

Here are a couple suggestions.

1. "Map" with wildcards instead of expanding the range. See

2. Expand the range using a while loop. See attached for an example.

-Rob

marcel_olmo — Fri, 02 Jan 2015 12:01:49 GMT

Thanks Elena! It works perfect, it just only needs to Iterno until 100 to complete the range.

Regards, Marcel.