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.
SOLVED

IF THEN Replace Statement

vujennyfer
7 - Meteor

Hello, 

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

 

 

 

PhilipMannering
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,

PhilipMannering_0-1614190620545.png

 

vujennyfer
7 - Meteor

This worked perfectly!! Thank you @PhilipMannering 🙂 

Labels