Vlookup using Alteryx
- 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
Hello All,
Im still very new to Alteryx and I have read through several posts to try and solve mine but I must be doing something wrong.
I have a main file (Sample 2) which has data such as the below:
EMPLOYEE |
KU4596 |
SN1264 |
4782000 |
1264000 |
I want to add the "Title" against each of these if they exist by looking up a file which may have the data in either column 1 or 2. The second file (Sample1) looks something like this:
EMPLOYEE NUMBER | EMPLOYEE SECONDARY | Title |
KU4596 | 4596000 | Risk Manager |
JH4782 | 4782000 | Safety Manager |
NE1264 | 1264000 | Compliance Manager |
JW1281 | 1281000 | Building Manager |
SN1264 | 1264000 | CEO |
HG7596 | 7596000 | Facilities Manager |
I tried the join tool but I dont seem to be getting the right output.
What am I doing wrong? Any help would be great.
Thanks in advance.
Solved! Go to Solution.
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You'll need to make use of two Join tools (one for each field you'd like to join) and then combine the results with a Union tool. I've put together an example. One thing to note is that "Sample 1.xlsx" uses "1264000" twice, which confuses the results of the second join.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could also use the find/replace tool and choose the option to append fields to record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Legend! Totally made my day. I was just using the one join tool to try and look up both columns.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks everyone for all your help
