I have a robot that get data from excel sheets and which inserts it in a SQL database.
I have to run the robot each month where the excel sheet either have new rows or some of the rows has been updated.
In the SQL table the columns are named
- UUID that is the primary key
I know I have to use the “Execute Non Query” activity. But how do I ensure that
When new UUID add it to the database and when UUID exist then update the different columns that is together with the UUID
Thank you in advance!