Hi All,
I have two files that I need to link and I cannot figure out the best way to do it.
The first file has two items user_ID and user_name. The second has multiple columns of data with names of people that hold job positions such as role_1, role_2, etc. The challenge is that these are Sharepoint lists and the export from Sharepoint only gives you the user_ID for each of these roles. I thought I could map these during the load, but I would need to map each of the columns back to the user file and unless I am wrong, mapping is only to connect one column.
Is there a way to create a master item that matches the number in role_1 to the user_ID field in the User Info List. In this example Role_1 = 15, User_ID 15 = zimmermann, amber. I want the role_1 for Cafeteria to show Zimmermann, Amber. Is this possible?
User List:
| ID | title |
| 14 | Smith, Fred |
| 15 | Zimmermann, Amber |
| 16 | Doe, Jane |
Role List:
| Location | role_1 | role_2 | role_3 |
| Market | 14 | 16 | 15 |
| Store | 16 | 15 | 14 |
| Cafeteria | 15 | 14 | 16 |
Desired view:
| Location | role_1 | role_2 | role_3 |
| Market | Smith, Fred | Doe, Jane | Zimmermann, Amber |
| Store | Doe, Jane | Zimmermann, Amber | Smith, Fred |
| Cafeteria | Zimmermann, Amber | Smith, Fred | Doe, Jane |
It would be great if there was a way to load these (btw...this is only a paired down example, I have about 20 roles that have these unique ids), but I am also okay with creating 20 master items. Anyone know how I can achieve this?
Thanks in Advance!
