Incremental Load

[kicchu465]

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.

[Anil_Babu_Samineni]

Not sure, i understand the problem? Will you provide how you want to load?

[eduardo_dimperio]

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