Reload Error

[varunreddy]

Hi Guys,

Can anyone correct this? This is giving that path is not found

vEnv = 'UAT';

set vUATSourceData = Z:\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\UAT\Data Files;

set vProdSourceData = Z:\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\Prod\Data Files;

set vPath = if($(vEnv) = UAT,$(vUATSourceData),
if($(vEnv) = 'Prod',$(vProdSourceData)));

Load * from

[$(vPath)\DQIM_AllIssues_History - Master_Post.xlsx]
(ooxml, embedded labels, table is Sheet1);

Error is that path is not found.

I am trying to parameterize the environment.

Regards,

Varun Reddy

[swuehl]

Try

LET vPath = if('$(vEnv)' = 'UAT','$(vUATSourceData)',
if('$(vEnv)' = 'Prod','$(vProdSourceData)'));

edit:

Your first line is missing a SET or LET statement, right?

[sunny_talwar]

May be this:

LET vUATSourceData = 'Z:\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\UAT\Data Files';

LET vProdSourceData = 'Z:\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\Prod\Data Files';

LET vPath = if($(vEnv) = 'UAT', $(vUATSourceData),
if($(vEnv) = 'Prod',$(vProdSourceData)));

Load * from

[$(vPath)\DQIM_AllIssues_History - Master_Post.xlsx]
(ooxml, embedded labels, table is Sheet1);

[#4]

Hello,

Try use LET instead SET in the :

LET vPath = if($(vEnv) = UAT,$(vUATSourceData),
if($(vEnv) = 'Prod',$(vProdSourceData)));

[varunreddy]

Hi Sunny,

Please find the error below:

[varunreddy]

Hi Swuel,

I corrected first line. I tried your syntax, But not working

Regards,

Varun

[varunreddy]

If I use Let, It is giving error as script line error

[quwok]

Alternatively, place the two data source path in single quotes.

[varunreddy]

I tried but no use. It is giving error as 'Systen Cannot find the Path'

[swuehl · Accepted solution]

Seems to work for me, just added a TRACE to check.

LET vEnv = 'UAT';

set vUATSourceData = Z:\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\UAT\Data Files;

set vProdSourceData = Z:\GDMP\01.GDMP\04. Data Quality\25. Data Quality Metrics & Reporting\98. Reporting\DQ_Qlikview\Prod\Data Files;

LET vPath = if('$(vEnv)' = 'UAT','$(vUATSourceData)',

if('$(vEnv)' = 'Prod','$(vProdSourceData)'));

TRACE Path: $(vPath);

Load * from

[$(vPath)\DQIM_AllIssues_History - Master_Post.xlsx]

(ooxml, embedded labels, table is Sheet1);

What is the error message you get now? Does the path exist?