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: 
Anonymous
Not applicable

Store old values in different table on update

Hello, I'm a newbie in Jaspersoft ETL. 

I'm trying to do an ETL process where if there is an update (on IDM_USER_V table) I would like to store the old values in a different table (that I call History). The problem is that the job is inserting all values, not only the ones being updated. How can I fix this? Below I provide a screenshot of the job.

Labels (4)
2 Replies
Prakhar1
Creator III
Creator III

Hi @amiv ,

Are you updating the old values ? or you are adding a new row with updated value ?

Prakhar1
Creator III
Creator III

Hi @amiv ,

Are you updating the old values ? or you are adding a new row with updated value ?