Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx Lookup Function

Ctraore
7 - Meteor

Hello, 

 

Need some help with Alteryx. In the sample file attached here, I am trying to replace the NULL values in the STATE, COUNTY and COUNTY SEAT fields by looking up the NAME. So, for example, STATE, COUNTY and COUNTY SEAT for John would be filled with NEBRASKA, ADAMS and HASTINGS. I have tried using the formula tool by using "IF c THEN t ELSE f ENDIF" but I am not really going anywhere. Thank you for your help.

2 REPLIES 2
binuacs
21 - Polaris

@Ctraore one way of doing this

image.png

Ctraore
7 - Meteor

It worked. I didn't mention here but the data had 2,000,000 records. So, I had to drop some fields that had values taken from the row above that were incorrect but the main fields I needed had the correct values. And that works for me. Thank you for your assistance.

Labels
Top Solution Authors