Forum Discussion
multiple queries for SPC data
I am pulling measurements in from an SPC system at my company but the data is coming in through 2 different queries called specs and data. The specs table has all a field called "type" and has the name of all of different measurements the personnel take (height, weight, width, etc.) as well as the upper spec limit (USL) and lower spec limit (LSL). The data query has individual columns with all of the measurements. Is there a relationship I can make between the two queries so that when someone wants to pull the measurements for a "type", it will pull the same "type" measurements from the data query?
Hi Anonymous,
Based on my test, you could refer to below steps:
Unpivot your 'Height', 'weight' and 'width‘ column:
Apply it and create relationships between two tbales:
Now you could see the result:
You could also download the pbix file to have a view.
Regards,
Daniel He
4 Replies
Tough to visualize. Sample/example data would make it much more clear. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
So this is essentially how the information looks. I'm looking for a relationship to tie together the "Variable" tab fromt the spec table and the correct variable column from the data table.
Specs Toy Description Variable Target USL LSL 76A Height 10 11 9 76A Weight 100 100.5 99.2 76A Width 4 4.3 3.7 86A Height 9 10 8 86A Weight 60 65 56 86A Width 3 3.4 2.8 Data Date Time Toy Description Height Weight Width 1/19/2019 13:45 76A 10.2 100.7 4.1 2/1/2019 1:45 76A 10.1 1010 3.7 2/10/2019 4:45 86A 9.3 62 3 Hi Anonymous,
Based on my test, you could refer to below steps:
Unpivot your 'Height', 'weight' and 'width‘ column:
Apply it and create relationships between two tbales:
Now you could see the result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi Anonymous ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?Regards,
Daniel He
