Forum Discussion

Si3rco's avatar
Si3rco
Frequent Visitor
2 years ago

Translate a Ressource Table in per Month

Hey

I have a table this looks like this:

RessourceIDDepartmentSkillStartDateMonthCapacity
Emplyee1ProjectmanagemtProjectmanager01.01.2023100%
Emplyee2EngineeringSystem Engineer 01.01.2023100%
Emplyee1ProjectmanagemtProjectmanager01.04.202350%
Emplyee3EngineeringSW System Engineer 01.04.2023100%
Emplyee2EngineeringSystem Engineer 01.10.20230%

 

And I want to translate this to a table where I have an entry per Employee with the Uniques from Department and Skill, per each Month. When the Capacity is 0 no entry before an after needed to keep the table slim. This should look like this:

 

RessourceIDDepartmentSkillStartDateMonthCapacity
Emplyee1ProjectmanagemtProjectmanager01.01.2023100%
Emplyee1ProjectmanagemtProjectmanager01.02.2023100%
Emplyee1ProjectmanagemtProjectmanager01.03.2023100%
Emplyee1ProjectmanagemtProjectmanager01.04.202350%
Emplyee1ProjectmanagemtProjectmanager01.05.202350%
Emplyee1ProjectmanagemtProjectmanager ...ongoning ...ongoning
Emplyee2EngineeringSystem Engineer 01.01.2023100%
Emplyee2EngineeringSystem Engineer 01.02.2023100%
Emplyee2EngineeringSystem Engineer 01.03.2023100%
Emplyee2EngineeringSystem Engineer 01.04.2023100%
Emplyee2EngineeringSystem Engineer 01.05.20230%
Emplyee3EngineeringSW System Engineer 01.04.2023100%
Emplyee3EngineeringSW System Engineer 01.05.2023100%
Emplyee3EngineeringSW System Engineer ...ongoning ...ongoning

 

Thanks for help.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Si3rco ,

    I'm a little confused about your needs, Could you please explain them further?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu

  • Si3rco's avatar
    Si3rco
    Frequent Visitor
    2 years ago

    I have a table where the resources (employees)  have an entry each time the capacity changes. For example, Emplyee1 starts to working on the 01.01.2023 100%. On the 01.04.2023 the capacity is changed to 50%. But there are no entries 01.02.2023 and 01.03.2023. 

     

    The goal is it to create a capacity chart, but for that, I need a table which has an entry per resource.

     

    Hope its clearer. ğŸ˜Š