topic STORE Script Command using a variable for path in QlikView

STORE Script Command using a variable for path

tschullo — Mon, 09 Nov 2015 17:24:58 GMT

Ok people, what am I doing wrong here?

LET vQVD_dir='..\QVD\debug\';
DIM_BUSINESS_LINE:
SQL

SELECT * FROM DIM_BUSINESS_LINE;
STORE DIM_BUSINESS_LINE INTO $(vQVD_dir)DIM_BUSINESS_LINE.QVD (QVD);
DROP TABLE DIM_BUSINESS_LINE;

Script blows up at STORE command.

My extractor is in the folder QV\EXTRACTORS

MY QVD folder is at QV\QVD

and I am trying to use a debug subdir QV\QVD\debug

What am I doing wrong? I've tried LET, SET, no quotes, with quotes.

Thanks,

Frustrated in NY

Re: STORE Script Command using a variable for path

swuehl — Mon, 09 Nov 2015 17:27:28 GMT

Does the debug folder already exist?

Re: STORE Script Command using a variable for path

tschullo — Mon, 09 Nov 2015 17:30:10 GMT

Yes, it does

Re: STORE Script Command using a variable for path

sunny_talwar — Mon, 09 Nov 2015 17:30:30 GMT

Script seems right to me. Is it giving you any specific error?

Re: STORE Script Command using a variable for path

VishalWaghole — Mon, 09 Nov 2015 17:36:39 GMT

Please post which error you are getting at STORE.

Re: STORE Script Command using a variable for path

swuehl — Mon, 09 Nov 2015 17:37:44 GMT

If you step into the script using the debugger, how does the expanded STORE command looks like?

Can you make it work using the hardcoded path?

Re: STORE Script Command using a variable for path

tschullo — Mon, 09 Nov 2015 17:39:45 GMT

Sorry folks, my bad.

I was running script on server, created debug folder locally, thought I was in local copy.

Re: STORE Script Command using a variable for path

swuehl — Mon, 09 Nov 2015 17:40:15 GMT

And just to double check: The user that runs the script has proper access rights to the folder and potentially already existing QVD and the potentially already existing QVD is not locked by another process?