Forum Discussion
Establishing relationship help
Hi, Without providing all the data, I am simply looking for a solution in terms of the best approach. TABLE 1: Business unit IDs with their location by STATE TABLE 2: Supplier IDs with their...
Hi Anonymous ,
Thanks for the recommendation.
Could you please explain what you meant by unpivot the supplier table?
Also, what should the unique stable table look like? Do I need to create a row for every combination of Coverage - State?
Cheers
Hi Anonymous
So you have to select all the rows but the supplier attributes, inside power query you have on transform pane a unpivot button.
Divide by the delimiter before you unpivot so it can create a column for every state and you select those columns and unpivot.
Then you make a relationship between the supplier table and the unpivoted one, then you just make a relationship between suppliers and the company and you have it.
Let me know if it worked if so mark as solution.
BR,
DR
So you have to select all the rows but the supplier attributes, inside power query you have on transform pane a unpivot button.
Divide by the delimiter before you unpivot so it can create a column for every state and you select those columns and unpivot.
Then you make a relationship between the supplier table and the unpivoted one, then you just make a relationship between suppliers and the company and you have it.
Let me know if it worked if so mark as solution.
BR,
DR