read files from one folder to another folder

[sakshikaul]

Hi,

I want to read files from one folder and move to another folder but following script is not giving the desired output after execution of the script(see image below)

let FilePath = [D:\Qlik_OrderSheets\final_order];
let vFilPathProceed =[D:\Qlik_OrderSheets\OrderSheets]
Full_Order_Data:

LOAD distinct Plant, 
OrderNo, 
OrderDate, 
OrderType, 
DistChannel, 
Division, 
NCODE, 
Season, 
MatType, 
Style, 
Color, 
Size, 
OrderQty, 
OrderValue, 
ConfirmedQty, 
ConfirmedValue, 
MRP
FROM
[D:\Qlik_OrderSheets\OrderSheets\QLIK*.CSV]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Execute cmd.exe /C Move $(FilePath) $(vFilPathProceed);

[anushree1]

Could you try this using store command instead of Execute

[sakshikaul]

store cmd.exe /C Move $(FilePath) $(vFilPathProceed);

This line is giving an error 

[anushree1]

No Store Command has a different Syntax , please check https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatement... and  https://community.qlik.com/t5/QlikView-App-Development/Multiple-Excel-file-load-and-save-each-to-qvd...

[anushree1]

No Store Command has a different Syntax , please check https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatement... and  https://community.qlik.com/t5/QlikView-App-Development/Multiple-Excel-file-load-and-save-each-to-qvd...

[pradosh_thakur]

let FilePath = "D:\Qlik_OrderSheets\final_order";
let vFilPathProceed = "D:\Qlik_OrderSheets\OrderSheets";
Execute cmd.exe /C Move $(FilePath) $(vFilPathProceed);


please make sure you allow qvw to execute the commands from it.

[pradosh_thakur]

make sure edit script-> settings -> can execute external programs is checked.

[sakshikaul]

Hi,

what do you mean by this?

"please make sure you allow qvw to execute the commands from it."

I am using QVW only to execute the script

[pradosh_thakur]

I mean script-> settings -> can execute external programs is checked.

If your qvw still is not able to do it try without variable and see if it's working and not a server related issue.

[sakshikaul]

you mean this?