Discussion Board for collaboration on QlikView Scripting.
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:
FROM FilePath&'FileName'&Ref&'.xls' (ooxml, embedded labels, header is 1 lines, table is DATA);
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?
Go to Solution.
It complained about the & and ' ', but it worked:
Everytime I use a variable, u must use it inside $()?