Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Loading data

Hi All,

I have a table with 1.6M + records and keep on adding daily basis on time stamp, for which I am trying to create a QVD from QVD Generator.

But the QVD Gen is taking more than 2 hours to run and create the QVD.

Moreover, I want only the records which have the latest time stamp.

Example:

Table of 1.6M

ID, Name, Time_Stamp

.

.

.

.

1, ABC, 6/6/2020

for today only the latest records ie 1, ABC should be picked

and for tomorrow the 1, ABC will be old record and which should be discarded and based on timestamp the latest record should be included.

I request your help.

Regards,

M. Parvez

1 Solution

Accepted Solutions
Specialist III
Specialist III

May be this will help to keep only the last record.

tab1:
Load ID, Name, Time_Stamp
Resident..;

Right Join(tab1)
Load ID, Name, Max(Time_Stamp) As Time_Stamp
Resident tab1
Group By ID, Name;

 

View solution in original post

2 Replies
Specialist III
Specialist III

May be this will help to keep only the last record.

tab1:
Load ID, Name, Time_Stamp
Resident..;

Right Join(tab1)
Load ID, Name, Max(Time_Stamp) As Time_Stamp
Resident tab1
Group By ID, Name;

 

View solution in original post

Digital Support
Digital Support

Would recommend reviewing the following links too:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/QVD_Incremental...

https://community.qlik.com/t5/Qlik-Design-Blog/Overview-of-Qlik-Incremental-Loading/ba-p/1466780

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.