community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Tool that acts like excels VLOOKUP

Meteor

Excuse my newbie question. I'm trying to use the join tool similar to using vlookup in excel. The only issue I see is that if the data does not match, it removes the rows that do not match between the 2 files for the J output.

 

Example:

 

If I have the 2 inputs going into a join tool, it will output the matching 11 rows and not the rest.

 

 

Input 1

input 1.PNG

 

Input 2

 

input 2.PNG

 

Instead of this output:

 

output no.PNG

 

 

I would want this output:

 

output yes.PNG

 

How can I do this?

 

 

Pulsar
Pulsar

Hey @rtlane! Use a Union tool after your Join on the L and/or R outputs. This should append the rows of data that were not joined.

Meteor

Wow thank you so much for the quick response. I knew it had to be something simple. lol 

Highlighted
Meteor

if i'm not mistaken, you can also lookup the price values based on ID using the find replace tool,

 

Oh, here it is:

  • Match values in a VLookUp table to values in an existing dataset

https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201

Labels