topic Copy command not working in QlikView

Copy command not working

lornafnb — Fri, 02 Jul 2021 17:05:34 GMT

hi guys

PFA

I store my qvd location in a variable called vQvDataWrite.

My qvd file fullname is a combination of vQvDataWrite and 'Africa_ ' and '$(vMaxRecPeriod).qvd'.

My code works correctly that it finds the qvd, but the copy statement fails.

I am sure its a combination of the variables and the constants not working.

Please can anyone assist?

Thanks.

kaushiknsolanki — Fri, 02 Jul 2021 18:44:07 GMT

Hi, You have extra '\' in execute command which is probably causing this issue. Try this.

execute cmd.exe /c copy "$(vQvDataWrite)Africa_$(vMaxRecPeriod).qvd" "$(vQvDataWrite)Backup";

I have removed "\" which was there before the Backup keyword.

lornafnb — Mon, 05 Jul 2021 08:40:23 GMT

thank you