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
Solved! Go to 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
Yes, this is exactly what I was looking for. Thanks so much for your help and the quick response.
Missy