Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody. I use the Vis.js timeline to visualize my projects. This is not a problem as long as the database looks like this:
Projekt | Meilenstein |
---|---|
Projekt A | 02/07/2018 |
Projekt A | 05/07/2018 |
Projekt B | 22/06/2018 |
Projekt A | 12/07/2018 |
Projekt B | 04/07/2018 |
Projekt C | 01/08/2018 |
Projekt C | 08/08/2018 |
This is displayed clean (with the necessary around it). One project per line with different milestones.
But I would like to have the data recorded as follows:
Projekt | Meilenstein 1 | Meilenstein 2 | Meilenstein 3 |
---|---|---|---|
Projekt A | 02/07/2018 | 05/07/2018 | 12/07/2018 |
Projekt B | 22/06/2018 | 04/07/2018 | |
Projekt C | 01/08/2018 | 08/08/2018 |
I had only thought to convert the Excel with MTrans or whatever. But I am not enough expert for that. I hope you can help me.
Hi Ronny,
The solution can be the The Generic Load, or:
The next will be just pseudo code:
stg1:
Load projekt,
meilenstein,
autonumber(projekt&meilenstein) as rnk
from
Hi Gabor,
Thanks alot for the tip with "Cross Table". This is exactly what I need. And it is easy to use.
Ronny