Alteryx Lookup Function

[Ctraore]

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.

[binuacs · Accepted solution]

@Ctraore one way of doing this

[Ctraore]

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.