Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Given the following code:
SET vFileName = ..\QVD\Extract\ClinicDashboard\RawWorkload_2014.qvd;
//LET vFileExists = NOT ISNULL(QvdCreateTime([$(vFileName)]));
//LET vFileExists = NOT ISNULL(FileTime([$(vFileName)]));
LET vFileExists = NOT ISNULL(FileSize([$(vFileName)]));
ALL of the three lines that start with "LET vFileExists" returns "0". However, when I do the following, the file loads without an issue:
LOAD * FROM $(vFileName) (qvd);
Why can't I find the file like I'm trying to do?
LET vFileExists = NOT ISNULL(FileSize('$(vFileName)'));
LET vFileExists = NOT ISNULL(FileSize('$(vFileName)'));