Formula Tool | moving data from one cell to another

[mschrupp]

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 solution]

Hi Missy,

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

	Pseudo code	Alteryx
Address Line 1	if 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] endif
Address Line 2	if 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

[mschrupp]

Yes, this is exactly what I was looking for. Thanks so much for your help and the quick response.

Missy