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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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 ?