topic Re: read files from one folder to another folder in QlikView

read files from one folder to another folder

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: read files from one folder to another folder

anushree1 — Wed, 06 Feb 2019 07:23:26 GMT

Could you try this using store command instead of Execute

Re: read files from one folder to another folder

sakshikaul — Wed, 06 Feb 2019 07:28:00 GMT

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

This line is giving an error

Re: read files from one folder to another folder

anushree1 — Wed, 06 Feb 2019 07:38:11 GMT

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

Re: read files from one folder to another folder

anushree1 — Wed, 06 Feb 2019 07:39:47 GMT

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 08:31:55 GMT

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.

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 08:33:48 GMT

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

Re: read files from one folder to another folder

sakshikaul — Wed, 06 Feb 2019 08:51:27 GMT

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

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 08:55:21 GMT

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.

Re: read files from one folder to another folder

sakshikaul — Wed, 06 Feb 2019 09:03:02 GMT

you mean this?

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 09:05:30 GMT

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.

Re: read files from one folder to another folder

sakshikaul — Wed, 06 Feb 2019 09:17:11 GMT

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

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 09:19:53 GMT

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

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 09:22:49 GMT

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

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 10:55:45 GMT

Did you get it working ?

Re: read files from one folder to another folder

sakshikaul — Wed, 06 Feb 2019 11:15:38 GMT

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:

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;

Re: read files from one folder to another folder

pradosh_thakur — Wed, 06 Feb 2019 11:53:54 GMT

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

Re: read files from one folder to another folder

sakshikaul — Wed, 06 Feb 2019 12:12:40 GMT

yes. Thanks