Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Comapring old data and updated data and highlight the updates

Hi Friends,

I was trying to do something fancy and got stuck.

I am pulling data from few excel sheets and those sheets get updated from users on daily basis. They may add data or may update the old data or may delete data. So I used to consolidate all the data together into one sheet.

Is there any way by which I can detect the updates which was done by the user today from the data loaded at the time of previous load?

Any help on this will be really appreciated.

Thanks and Regards

Jyothish KC

Best Regards,
KC
3 Replies
Highlighted
Master II
Master II

Re: Comapring old data and updated data and highlight the updates

Hello All,

Any help on this?

jaganmohan tresesco

Regards

KC

Best Regards,
KC
Highlighted
MVP
MVP

Re: Comapring old data and updated data and highlight the updates

Create qvd daily; compare yesterday's qvd data with the excel data to be loaded today. To do this there has to be a unique identifier of the record i.e. primary key. But here without the timestamp you might not be able to implement effective incremental load(which you possibly are not looking for).

Highlighted
Master II
Master II

Re: Comapring old data and updated data and highlight the updates

Thanks a lot tresesco for the logic.

l will try to implement this.

Regards

KC

Best Regards,
KC