Thread: Table Insert/Update only when field is NULL

Hi, I tried it out and i think I got it to work. I first tried the Merge Diff step but the way you described it you'll only have the new/changed row without knowing what the original value was. Using the "Merge Join" step solved the problem. I now have old and new data together and can use the calculator step. It gives me the desired result. I added a screenshot in case someone else will run into the same issue. Thanks...

I'd suggest looking at the following steps: 1. Get sorted data from table 2. Get sorted new data 3. Join #1 and #2 with a Merge Diff Step 4. Filter the Joined data for only changed records 5. Calculator step using NVL to get the non-null value for every field (if it exists) 6. Update step inserting your NVLed fields

you can also do a Execute SQL Script: update tableA set last_name = decode(last_name, null, '?', last_name), first_name = decode(first_name, null, '?', first_name) , email = decode(email,null,'?',email) where id = ? Enable "Execute for each row" & "Variable substitution"