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.

Tool that acts like excels VLOOKUP

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.




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?



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.

7 - Meteor

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

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