Alteryx Lookup Function
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Datasets
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Ctraore one way of doing this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
