topic Re: Reload Error in QlikView

Reload Error

varunreddy — Mon, 16 Nov 2015 18:47:45 GMT

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

Re: Reload Error

swuehl — Mon, 16 Nov 2015 18:50:47 GMT

Try

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

edit:

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

Re: Reload Error

sunny_talwar — Mon, 16 Nov 2015 18:53:27 GMT

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);

Re: Reload Error

Mon, 16 Nov 2015 18:54:49 GMT

Hello,

Try use LET instead SET in the :

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

Re: Reload Error

varunreddy — Mon, 16 Nov 2015 18:56:19 GMT

Hi Sunny,

Please find the error below:

Re: Reload Error

varunreddy — Mon, 16 Nov 2015 18:58:50 GMT

Hi Swuel,

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

Regards,

Varun

Re: Reload Error

varunreddy — Mon, 16 Nov 2015 18:59:58 GMT

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

Re: Reload Error

quwok — Mon, 16 Nov 2015 19:00:29 GMT

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

Re: Reload Error

varunreddy — Mon, 16 Nov 2015 19:01:53 GMT

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

Re: Reload Error

swuehl — Mon, 16 Nov 2015 19:07:36 GMT

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?

Re: Reload Error

varunreddy — Mon, 16 Nov 2015 19:12:37 GMT

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

Re: Reload Error

swuehl — Mon, 16 Nov 2015 19:29:21 GMT

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).

Re: Reload Error

Mon, 16 Nov 2015 21:37:05 GMT

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