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

[varunreddy]

Swuel,

This works,

Can you explain

1. why did you use Let for vEnv, as it is not an aggregation?

2. why are you adding single quotes to variables?

Thanks for the time.

Cheers,

Varun

[swuehl]

1. ???

What is the connection of the LET statement to an aggregation you are implying in your question?

Take a look in the HELP, LET and SET statements in the script.

2. That's how you expand variables to a string literal (unless the variable itself already contains the single quotes).

[#4]

Use LET function instead of SET. Always use LET if you are evaluating any thing.