Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to do file handling in Qlikview.I have following scenario:-
I have full load files present on FTP(as below) which I have stored in QVD and then loaded in qlikview script (refer red color code) and I have deleted those full load files from FTP after taking in QVD format.
similarly, I have another files (incremental load ) that are created on daily basis on same FTP where full load files are kept(refer green color code below)
///////Increment Order/////////////////
LET vToday = date(today(), 'YYYYMMDD');
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);
////////////////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;
Now I want to confirm whether the above code will work for the following below scenario?
I want the increment load (files ) which are created on daily basis on FTP, should get overwrite in existing full load (refer code above). The following code will execute incremental files (created on daily basis)
FROM
[D:\Qlik_OrderSheets\OrderSheets\QLIK*.CSV]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
1. and will it overwrite the files in full load???. Following is the code for that
FROM
[D:\Qlik_OrderSheets\OrderSheets\Full_Order_Data.qvd]
(qvd)
where not exists(NCODE, Style&Color&Size);