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.
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.
You could also use the find/replace tool and choose the option to append fields to record.
Legend! Totally made my day. I was just using the one join tool to try and look up both columns.
Thanks everyone for all your help