Formula Tool | moving data from one cell to another

Question

Please see screen shot below:

How do I write the Expression in the Formula Tool to fix records that have data in Address Line 2, but not in Address Line 1?

IF NULL, I would like to move the data FROM Address Line 2 TO Address Line 1 and null out Address Line 2

Thanks for your help!
Missy

PaulN · Accepted Answer

Hi Missy,

If I understand your request correctly you need to do 2 things:

Pseudo codeAlteryxAddress Line 1if Address Line 1 is empty then                                         => by empty we mean NULL or empty string ("")

Address Line 1 = Address Line 2

else

Address Line 1 should remain untouched

IF IsEmpty([Address Line 1]) then
   [Address Line 2]
else
   [Address Line 1]
endifAddress Line 2if Address Line 1 equals to Address Line 2 then

Address Line 2 should be empty

else

Address Line 2 should remain untouched

if [Address Line 1]==[Address Line 2] then
   ""
else
   [Address Line 2]
endif

References:

https://help.alteryx.com/11.5/index.htm#Reference/Functions.htm?Highlight=isempty

https://help.alteryx.com/11.5/index.htm#Reference/Functions.htm?Highlight=IF

Kind regards,

Paul Noirel

Customer Support Engineer