Forum Discussion
Pafmatos
3 years agoNew Member
Help - Show the same commitment (value) every day!
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!
No RepliesBe the first to reply