topic Re: use/set variables in execute statement in QlikView

use/set variables in execute statement

yelin_nyu — Wed, 18 Mar 2015 15:31:18 GMT

I have a execute statement to extract from zip file. but the file name will have a different date each week.

the file location has many batches of data, I need to make sure im picking up the right week's data.

I set the variables in qlikview, tried to use it in the file name in the execute statement, but it's not working.

let vFileName='Hey_';
let vBatch=date(weekstart(today()),'YYYYMMDD');
let vFileExt='.zip';
let vFile=vFileName&vBatch&vFileExt;

execute "\\MyFilePath\7za.exe" e \\\MyFilePath\FTP\$(vFile) -y -o\\MyFilePath\Input\*;

Re: use/set variables in execute statement

rubenmarin — Wed, 18 Mar 2015 15:38:36 GMT

Hi yelin, I think it should work, maybe is the triple-dash in \\\MyFilePath\FTP or it need to add a space between -o and the path in -o\\MyFilePath\Input\*;

Re: use/set variables in execute statement

yelin_nyu — Wed, 18 Mar 2015 15:51:15 GMT

it's the triple \, im so sorry to waste everyone's time. however you cannot put a space btw -o and the file path, it would not work. part of the syntax I believe. took me a couple trial and error to figure that out.