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 ...
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
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 |
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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