Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Skip blank records in a join

JohnO
7 - Meteor

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
17 - Castor

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
7 - Meteor

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

Labels