topic Re: Incremental Load in QlikView

Incremental Load

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

Hi Guys,

I'm having sample data in some format in excel as shown below.

But I have converted this data into another format which is convenient for me as shown in the below screenshot.

But I need to apply incremental logic while extracting the data itself i.e first screenshot - excel file. I want this to load on daily basis based on incremental load, since it will have only historic data there is no need for me to run all the data again and again.

But my concern here is, I couldn't load the maximum date since the source excel data format is not in proper format. So, please suggest me how can I implement incremental logic for this sort of data.

Attached the sample data.

Thanks,

Siva.

Re: Incremental Load

sunny_talwar — Thu, 24 May 2018 15:34:53 GMT

What is wrong with the date? Didn't we create date in this thread?

Data Format Change in QV

Re: Incremental Load

Anonymous — Thu, 24 May 2018 15:39:15 GMT

Yes Sunny, We created the date successfully in that thread. But I also need to apply incremental logic before creating the date column - I want to load the data on daily basis using incremental load.

Re: Incremental Load

sunny_talwar — Thu, 24 May 2018 15:48:28 GMT

Not sure how you would do that? Is there another way to identify which rows are new?