Vlookup using a single table
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
