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);

[pradosh_thakur]

This one as well as
go to edit script(ctrl+e) then in the bottom where there is odbc connection etc are there you can see a setting tab-> can execute external programs is checked.

[sakshikaul]

Its not working after i checked this "can execute external programs"

so I am trying without variable so this will be the syntax right?

FROM
[D:\Qlik_OrderSheets\OrderSheets\QLIK*.CSV]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
//store Full_Order_Data into D:\Qlik_OrderSheets\final_order.qvd;
Execute cmd.exe /C Move [D:\Qlik_OrderSheets\OrderSheets] [D:\Qlik_OrderSheets\final_order];

[pradosh_thakur]

Include them in double quotes and I think you are missing the file names in the source folder.

[pradosh_thakur · Accepted solution]

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

[pradosh_thakur]

Did you get it working ?

[sakshikaul]

Hi

I want to implement increment load and for that I have several csv files which are provided to me on daily basis in a given following folder (OrderSheets ) and now that files should be read from that folder(Order_sheets) and then stored in qvd one by one after reading and then move to a different folder after saved in qvd (final_order)(refer image below)

once the entire process is done the files saved in QVD after reading should be then overwritten in Full Load (Please refer Code Below) 

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);

store Full_Order_Data into D:\Qlik_OrderSheets\final_order.qvd;
Execute cmd.exe /C Move "D:\Qlik_OrderSheets\OrderSheets\QLIK*" "D:\Qlik_OrderSheets\final_order";
Full_Order_Data:

LOAD Plant,
OrderNo,
OrderDate,
OrderType,
DistChannel,
Division,
NCODE,
Season,
MatType,
Style,
Color,
Size,
OrderQty,
OrderValue,
ConfirmedQty,
ConfirmedValue,
MRP
FROM
[D:\Qlik_OrderSheets\final_order\QLIK*.CSV]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//////////////////Full Load Order///////////////////////////////
concatenate(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\Full_Order_Data.qvd]
(qvd)
where not exists(NCODE, Style&Color&Size);

store Full_Order_Data into C:\Users\dmsadmin\Desktop\New folder\QVD\extract_qvd\Full_Order_Data.qvd;
drop table Full_Order_Data;

[pradosh_thakur]

what is the issue now ? Are the file getting transferred or not ?

[sakshikaul]

yes. Thanks