Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try:
FROM $(FilePath)&'FileName'&$(Ref)&'.xls'
Try:
FROM $(FilePath)&'FileName'&$(Ref)&'.xls'
It complained about the & and ' ', but it worked:
FROM $(FilePath)FileName$(Ref).xls
Everytime I use a variable, u must use it inside $()?