Join two tables but keep specific fields from both
- 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
Hi - I have two tables that I need to combine by 'Employee ID'. Table A has employee ID as well as some other columns with entitlement information about the employee. Table B has employee ID as well as the employee's supervisor name and ID in separate columns along with a bunch of other random columns without information I care about. How would I join the two tables together to keep all of the information from table A, but just add two columns that match the employee ID from table A to the employee ID from table B and include the supervisor name and ID?
I don't want to change the number of rows in the output table from the number of rows in Table A (table B is more of a directory that I am using to just pull the employees supervisor info from).
Edited with example table below... the actual files are bigger and more complex, but this is what I'm trying to accomplish...
Table A:
Employee ID | Access | Level |
123 | group 1 | low |
456 | group 2 | medium |
789 | group 3 | high |
Table B:
Employee ID | Useless | Supervisor ID | Supervisor Name | Useless | Useless |
123 | a | 321 | John | b | c |
234 | a | 432 | Brett | b | c |
345 | a | 543 | Ryan | b | c |
456 | a | 654 | James | b | c |
567 | a | 765 | Brenda | b | c |
678 | a | 876 | Kate | b | c |
789 | a | 987 | Jane | b | c |
Output:
Employee ID | Access | Level | Supervisor ID | Supervisor Name |
123 | group 1 | low | 321 | John |
456 | group 2 | medium | 654 | James |
789 | group 3 | high | 987 | Jane |
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @hovicke ,
Join tool allows you to select fields you want to output.
So you can uncheck the unnecessary fields as below.
I hope this answered to your question.