Hey,
What I have:
- A simple date table with every day from 01/01/2021 to 01/01/2030
| Date |
| 01/01/2021 |
| 02/01/2021 |
| 03/01/2021 |
| 04/01/2021 |
| 05/01/2021 |
| 06/01/2021 |
- A table with 4 columns:
- Daily Commitment (how many units I should transport every day), which is always the same for every day
- The start date
- The departure and arrival
The table looks like this:
| Departure | Arrival | Start Date | Commitment |
| Madrid | Berlin | 01/01/2021 | 100 |
| Paris | London | 05/05/2021 | 150 |
| Munich | Lisbon | 01/01/2021 | 200 |
| Brussels | Barcelona | 20/01/2021 | 250 |
What I'm looking for:
I want to see the daily vision for the commitment, taking into account the start date:
| Date | Departure | Arrival | Commitment |
| 01/01/2021 | Madrid | Berlin | 100 |
| 01/01/2021 | Munich | Munich | 200 |
| 02/01/2021 | Madrid | Berlin | 100 |
| 02/01/2021 | Munich | Munich | 200 |
| 03/01/2021 | Madrid | Berlin | 100 |
| 03/01/2021 | Munich | Munich | 200 |
Note: the other locations when appear when the 'date' is equal or higher the start date
Recap: I want to join a date table with the commitment table, making sure the the commitment appears every day after the start date is achieved
Thank you all for your help!
