ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

IF THEN Replace Statement

7 - Meteor


I am trying to use the IF THEN statement to count the max addresses for a given name and then replace all the addresses with the most populated one. To goal is to have one address per name. 


IF [_current_name_]

THEN count(max(address_1)) AND

REPLACE(address_1, city, state, zip) with max(address_1, city, state, zip)


before: vujennyfer_0-1614189838742.png

after: vujennyfer_1-1614189897859.png




14 - Magnetar
14 - Magnetar

Hey @vujennyfer 


You won't be able to do this in the Formula Tool. Your best bet is something like this,



7 - Meteor

This worked perfectly!! Thank you @PhilipMannering 🙂