This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to implement Update:Insert if new logic when i am trying to insert records into the database table.I don't see this option when I use Write data In-DBtool .Is this even possible using InDB tools?
I have my master table where i have column as below
Now i receive my daily transaction table where lets say i receive 10 records.Out of this 5 customers already exists in my master table and 5 are new.So for new customer i can just append there records in my main table.But for 5 existing customers i need to updated the Quantity value based on data from today's transaction and update this records in my master table.
So basically i want to update existing customers with there new value.For this I do left join and can filter out records where right table is not Null and get customers which already exists in my master table.
No I need a way to append this records to my master table.