Forum Discussion

Pafmatos's avatar
Pafmatos
New Member
3 years ago

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: 

 

DepartureArrivalStart DateCommitment
MadridBerlin01/01/2021100
Paris London05/05/2021150
MunichLisbon01/01/2021200
Brussels Barcelona20/01/2021250

 

What I'm looking for: 

 

I want to see the daily vision for the commitment, taking into account the start date:

 

DateDeparture ArrivalCommitment
01/01/2021MadridBerlin100
01/01/2021MunichMunich200
02/01/2021MadridBerlin100
02/01/2021MunichMunich200
03/01/2021MadridBerlin100
03/01/2021MunichMunich200

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