Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

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

Skip blank records in a join

JohnO
5 - Atom

Is there a way I can skip blank or nonexistent records while doing a join?

 

I have a list of 200 client names and addresses. I need to join it with a list of client names and phone numbers. However only about 150 of the clients names have associated phone numbers, so when I use the Join tool, the list is pared down to items that have both and address and a phone number.  How can I tell Alteryx to skip a record that doesn't have a phone number and just leave it blank.

 

In Excel I'd just do a VLOOKUP.

 

Thanks,

John

3 REPLIES 3
Luke_C
13 - Pulsar

Hi @JohnO 

 

Here are two options

 

  1. Do the join, and then union the data that is dropping out
  2. Use the find and replace tool's 'append fields' option

 

Luke_C_0-1623359925518.png

 

Jonny
11 - Bolide

Hi @JohnO ,

 

You could use a Union tool to join the L and J Join tool outputs, I think it will do the trick.

Jonny_0-1623360137470.png

Jonny_1-1623360183930.png

 

JohnO
5 - Atom

Thank both of you so much! Both of these solutions do what I need them to do.

Labels