Translate a Ressource Table in per Month

[Si3rco]

Hey

I have a table this looks like this:

RessourceID	Department	Skill	StartDateMonth	Capacity
Emplyee1	Projectmanagemt	Projectmanager	01.01.2023	100%
Emplyee2	Engineering	System Engineer	01.01.2023	100%
Emplyee1	Projectmanagemt	Projectmanager	01.04.2023	50%
Emplyee3	Engineering	SW System Engineer	01.04.2023	100%
Emplyee2	Engineering	System Engineer	01.10.2023	0%

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:

RessourceID	Department	Skill	StartDateMonth	Capacity
Emplyee1	Projectmanagemt	Projectmanager	01.01.2023	100%
Emplyee1	Projectmanagemt	Projectmanager	01.02.2023	100%
Emplyee1	Projectmanagemt	Projectmanager	01.03.2023	100%
Emplyee1	Projectmanagemt	Projectmanager	01.04.2023	50%
Emplyee1	Projectmanagemt	Projectmanager	01.05.2023	50%
Emplyee1	Projectmanagemt	Projectmanager	...ongoning	...ongoning
Emplyee2	Engineering	System Engineer	01.01.2023	100%
Emplyee2	Engineering	System Engineer	01.02.2023	100%
Emplyee2	Engineering	System Engineer	01.03.2023	100%
Emplyee2	Engineering	System Engineer	01.04.2023	100%
Emplyee2	Engineering	System Engineer	01.05.2023	0%
Emplyee3	Engineering	SW System Engineer	01.04.2023	100%
Emplyee3	Engineering	SW System Engineer	01.05.2023	100%
Emplyee3	Engineering	SW System Engineer	...ongoning	...ongoning

Thanks for help.

[Si3rco]

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. 😊

[Anonymous]

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