Forum Discussion
Adam13Hylo
Helper I
Helper IMultiple SharePoint Lookup Columns Relationships
Hi all, I am having trouble and was wondering if someone could please help and advise me. I have a SharePoint custom list which contains 5 lookup columns all of the same lookup, for example:...
Hi Adam13Hylo,
If we can combine the five columns into one, it will be easy to create relationship.
1. Open Query Editor;
2. Select the five columns with "Shift" or "Ctrl";
3. Click "Unpivot Only Selected Column".
4. Change column names if needed.
Best Regards!
Dale
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Adam13Hylo,
If we can combine the five columns into one, it will be easy to create relationship.
1. Open Query Editor;
2. Select the five columns with "Shift" or "Ctrl";
3. Click "Unpivot Only Selected Column".
4. Change column names if needed.
Best Regards!
Dale