topic Re: Incremental Load in QlikView

Incremental Load

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

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.

Re: Incremental Load

Anil_Babu_Samineni — Fri, 05 Jan 2018 12:59:01 GMT

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

Re: Incremental Load

eduardo_dimperio — Fri, 05 Jan 2018 13:10:56 GMT

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