Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
Creator II
Creator II

read files from one folder to another folder

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)

Untitled.png
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);

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

Execute cmd.exe /C Move "D:\Qlik_OrderSheets\OrderSheets\QLIK*.CSV" "D:\Qlik_OrderSheets\final_order";
Learning never stops.

View solution in original post

17 Replies
anushree1
Specialist II
Specialist II

Could you try this using store command instead of Execute

sakshikaul
Creator II
Creator II
Author

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

This line is giving an error 


Untitled.png

 

pradosh_thakur
Master II
Master II

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.

Learning never stops.
pradosh_thakur
Master II
Master II

make sure edit script-> settings -> can execute external programs is checked.
Learning never stops.
sakshikaul
Creator II
Creator II
Author

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
Master II
Master II

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.
Learning never stops.
sakshikaul
Creator II
Creator II
Author

you mean this?

Untitled.png