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?
