topic Re: Re: load files with year in name in QlikView

load files with year in name

Fri, 09 Aug 2013 11:11:58 GMT

Hi All,

I need to load a files like this:

col1

col2

[col3 2012] as col3

[col4 2012] as col4

FROM table 2012;

col1

col2

[col3 2013] as col3

[col4 2013] as col4

FROM table 2013;

....

I want to avoid manual adding script every year so wanted to use loop with a variable. I know how to run the loop, however i cant manage to load the two fields (col 3 and 4) as variables... Could you please suggest how to do that?

Many thanks

Re: load files with year in name

marcus_sommer — Fri, 09 Aug 2013 11:22:42 GMT

You could use the columns position:

@3 as col3

- Marcus

Re: load files with year in name

Wed, 21 Aug 2013 09:31:35 GMT

That could help, but i am loading a qvd... so no chance for no labels.

Any other idea?

Re: Re: load files with year in name

sparur — Wed, 21 Aug 2013 09:38:34 GMT

Hi,

I think this loop could help:

for i = 2012 TO 2013

LET vField1 = 'col3 ' & '$(i)';

LET vField2 = 'col4 ' & '$(i)';

LET vQVDName = 'Table ' & '$(i)';

LOAD

col1,

col2,

[$(vField1)] as col3,

[$(vField2)] as col4

FROM [$(vQVDName).qvd]

Re: Re: load files with year in name

Wed, 21 Aug 2013 10:22:27 GMT

Perfect. It works.

Thanks Anatoly.