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
9 - Comet

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