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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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