Re: Updating destination table

OK it is ready for you nowClick data-targetClick transformationsTick user-defined SQL then edit every SQL statement individually. To regenerate the SQL statements clear it and open it again.You need to be very careful with this option.Keep the fields order the same and if there are any changes with the target table structure, regenerate everything againRemember with great power comes a great opportunity to make mistakes

Hello and thanks for looking at this. But with an Update statement, there is no way to be sure that only newly inserted lines in the SparesTransactions table will update the LocationsPerSpare table. If a line is updated for instance, the date column will be updated, and the line will be resent again to LocationPerSpate.

I think the only way is to use SQL after and update totals every time