Aggregate two tables onto one granulity

joslaz

Board Regular
Joined
May 24, 2018
Messages
71
Hello everybody,


I have two tables in the following format:

tblSkills:
NameIDFunctionAssemblyDrillingPolishingPackage
Jeremy001Operator1100
Rodger002Operator1000

<tbody>
</tbody>


tblPlanning:
DateIDState
01.01.2019001Assembly
01.01.2019001Drilling

<tbody>
</tbody>




It can be seen that the first table is partly a cross table.
The other table is a classic list.


Both can be linked using a calendar table and a master data list (name, ID).
Now I have to somehow connect the abilities with each other, in order to be able to carry out appropriate evaluations with the help of a pivot table.
Does anyone of you have any idea which structure would be best for this?


Best regards
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
4,247
I assume you want to join these two tables into one so via PQ

tblSkills
- select first three columns and Unpivot Other Columns
- change Attribute to State

merge tblSkills and tblPlanning by ID and State
- Expand

create PivotTable from Merge-Table
 
Last edited:

joslaz

Board Regular
Joined
May 24, 2018
Messages
71
Thanks for the replies!

I dont want a Merge of both tables in one. I am looking for a data modell.
So, I think a need a reference table with unique values for ID, the skills and the dates.
The challange is to determine a referance table for the skills.
How would you manage that?
 

Forum statistics

Threads
1,085,513
Messages
5,384,107
Members
401,881
Latest member
Dato

Some videos you may like

This Week's Hot Topics

Top