Generate Rows by sum of DateTime

[filipembribeiro]

Hi my friends!

I am building a model to discover at a certain moment of time how many airplanes I have in the ground in an Airport.

For this, I have the sample dataset, which tells us what flight it is [Flight ID], when it arrived and departed [DateTime_Arrival] and [DateTime_Departure], and the respectives times [Time_Arrival] and [Time_Departure].

Now, to know how many airplanes I have simultaneously on the airport, I need to create a vector for each time range (an hour) that the airplane is on the airport (the time between Time_Arrival and Time_Departure). This will generate several rows for each travel:

Important: every plane which is on the airport between 00:00:00 and 00:59:59 is on the 00:00 range, between 01:00:00 and 01:59:59 on the 01:00 range...

How can I make this vector work? I need to create it.

After this, I will count through a summarize tool how many airplanes I have in each Time Range.

Thank you very much

[BS_THE_ANALYST · Accepted solution]

@filipembribeiro here's one way:

workflow is attached

[filipembribeiro]

It worked! Thank you