Discussion board where members can get started with QlikView.
I have scenario to load the multiple files created on same time in qlik view using Incremental Load.
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?
Try create a Aux Qvd to Concatenate with the created. Something like this
Store Aux Into [lib:\\ YourPath\Aux.qvd](qvd);
Drop Table NewQvd;
Store DistinctFiles Into [lib:\\ YourPath\XYZ.qvd](qvd);