Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannagr
Creator III
Creator III

What do we do if we want to do update incremental load to a table that doesn't have its own time field?

My question is basically this on the title of the topic.

I have a table that can be updated, but on its own doesn't have a modification time field.

What do i do ? 

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

If you are using SQL Server, you can add a type rowversion column to the table. That will allow you to easily detect new or changed rows. Other database platforms may have a similar option. 

If that is not a solution, could you describe your data a bit more?  Is is only new rows you need or changed rows as well?  Is there some sort of incrementing record identifier?

-Rob