Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Incremental Load

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.

2 Replies
Highlighted

Re: Incremental Load

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist II
Specialist II

Re: Incremental 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);