Setting a Variable in "LOAD" in Scripts

Thu, 27 Dec 2012 12:22:27 GMT

Hello,

My data sources change monthly, and all are excel files with "YY-MM" at the end of the file name, so to make it easier to change those references, I'd like to set two variables, like this:

Set FilePath='C:/Path' //Just an example

Set Ref='AA-MM' //With YY being current year and MM last month, i.e.: 12-11

I'd then use this variables in LOAD field of my sources, like:

[Example]:

LOAD Data1,

Data2

FROM FilePath&'FileName'&Ref&'.xls' (ooxml, embedded labels, header is 1 lines, table is DATA);

Instead of:

[Example2]:

LOAD Data,
Data2

FROM
(biff, embedded labels, header is 1 lines, table is DATA);

However, this does not seem to work, as Qlikview searches for the root folder of my .qvw file first instead of going to FilePath. Is there any way to do this?

Re: Setting a Variable in "LOAD" in Scripts

Gysbert_Wassenaar — Thu, 27 Dec 2012 12:36:24 GMT

Try:

FROM $(FilePath)&'FileName'&$(Ref)&'.xls'

Re: Setting a Variable in "LOAD" in Scripts

Thu, 27 Dec 2012 13:11:45 GMT

It complained about the & and ' ', but it worked:

FROM $(FilePath)FileName$(Ref).xls

Everytime I use a variable, u must use it inside $()?

topic Setting a Variable in "LOAD" in Scripts in QlikView

Setting a Variable in "LOAD" in Scripts

Re: Setting a Variable in "LOAD" in Scripts

Re: Setting a Variable in "LOAD" in Scripts