Vlookup using a single table

[adesai0730]

I have a big list of data that I need to parse through. All of my data is currently in one data table. I was able to get the logic to work in excel for vlookup but am having trouble translating into Alteryx. I have posted a sample of the data below. The general rule is, if the Level 2 value is anywhere in Level 3, take the corresponding L2 value (parent) of that L3 and replace it with the current. 

For example 

Level 2, 111111111 is found in Level 3 (111111111, Company C). I would then like to replace that Level 2 value with the PARENT of the found Level 3. In this case, it would be replaced by 444444444, Company D. So in short, Level 2, 111111111/Company C becomes 444444444/Company D

Level 2	Level 2 Name	Level 3	Level 3 Name
222222222	Company E	999999999	Company M
333333333	Company B	10101010	Company N
333333333	Company B	20202020	Company L
111111111	Company C	30303030	Company O
111111111	Company C	40404040	Company K
444444444	Company D	111111111	Company C
444444444	Company D	111111111	Company C
555555555	Company F	555555555	Company F
666666666	Company G	50505050	Company J
666666666	Company G	50505050	Company J
777777777	Company H	777777777	Company H
111111111	Company C	60606060	Company A
111111111	Company C	60606060	Company A
888888888	Company I	70707070	Company A
888888888	Company I	70707070	Company A
333333333	Company B	80808080	Company B

[mceleavey]

Hi @adesai0730 ,

I'm not sure what you want to see, but this functionality is achieved by using the join tool.

Remember, the join tool is better than a vlookup as it will return all matches not only the first value.

I hope this helps,

M.

[adesai0730]

Hi, 

Thank you! This is what I was looking for. What would be the best way to append that data now? Specifically just the parent and parent name