Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Tool that acts like excels VLOOKUP

Highlighted
7 - 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?

 

 

Highlighted
14 - Magnetar
14 - Magnetar

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.

Highlighted
7 - Meteor

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

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