I have two table having some data. i need to lookup the matched values from two tables. first matched value only. i have attached the screenshot. how to achieve the result through alteryx.
It’s important to note that Excel’s VLOOKUP will pick up the first valid value that you are marking against.
Whereas in Alteryx, using the Join tool to map a value could result in multiple outcomes due to its relationship (one-to-many, many-to-one, etc.).
So if you want to map exactly, you either use more keys to map in your join tool or you use a Unique tool to get your figure - you may also need to sort if your data is ordinal.
You need to remove dupliacates from table2 (col. User id2)
This will remove the 2nd occurrence.
Then use find and replace tool to get the desired results.
If possible. Please share complete data or workflow
Use export workflow to save the workflow.
Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.
Thank you for your response ,
I cant remove 2nd occurrence, my requirement is to : pick up first matched value from 2nd table.
In excel Vlookup matches first occurrence value.
Hi @Pratik1996 I would recommend you have a look at the Alteryx & Excel Guide and specifically Alteryx for Excel Users: How to do a VLOOKUP in Alteryx.
For the same length for a Find, Alteryx will select the last value. So you could reverse your table before the Find and Replace table. (Alternatively you could use the Unique Tool as others have suggested).
See potential solution attached,
