The problem I’m having
creating a incremental model that appends records to the target table and if they exists then update the version_number + 1 without deleting the existing records for this date
The context of why I’m trying to do this
because i want to see the history of the given date what is changed on this given referenced date. If I already have records on the target table lets say on 2024-02-18 with version==1
Then I would like to append the incoming records on the same date but with max(version) + 1
Thanks a lot, maki.markie