Rule Engine or Expression Node for updating a recordset

For a Table containing contact information

In SQL I could do something like one field is empty replace with another field : i…e If length(myField1)<1 then set myField1 = myField2

Doing this logic and updating records does not seem very intuitive and seems to take many steps.

Basic conditional logic using the fields to set and update values