Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have scenario to load the multiple files created on same time in qlik view using Incremental Load.
for example:
In my folder I have files as below.
file name created date and time
XYZ.xlx 01/05/2018 5.28
XYZ.xls 01/05/2018 5.27
XYZ.xls 01/04/2018 4.00
The data is being loaded successfully first file i.e created on 01/05/2018 5.27 and when I am adding the new file created on 01/05/2018 5.28 the data from first file is gone.
Is there any way to achieve this.
If you can also provide me the script then that would be much appreciated.
Not sure, i understand the problem? Will you provide how you want to load?
Hi SK
Try create a Aux Qvd to Concatenate with the created. Something like this
Aux:
Load
*
Resident YourTable
Store Aux Into [lib:\\ YourPath\Aux.qvd](qvd);
NewQvd:
Load
*
From
XYZ.qvd
Concatenate (NewQvd)
Load
*
From
Aux;
NoConcatenate
DistinctFiles:
Load
Distinct
*
Resident NewQvd;
Drop Table NewQvd;
Store DistinctFiles Into [lib:\\ YourPath\XYZ.qvd](qvd);