File Handling (Incremental Load)

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

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

topic File Handling (Incremental Load) in QlikView

File Handling (Incremental Load)