Update logic

[jay_viz]

I have a customer table with Customer ID, state customer belongs, Sales Rep and Sales Region of the customer. I am trying to get an update/insert logic working. What I am trying is to get to is -

If an existing customer comes in with a change in the state then –> Change State and void Sales Rep and Region

If an existing customer comes with same state information then –> No action

If a new customer comes in then –> Insert the customer to the table

Here is the data format

Looking for help in achieving this

[gautiergodard · Accepted solution]

hey @jay_viz 

would something like this work?

[BS_THE_ANALYST · Accepted solution]

Here's one way @jay_viz :