Create table using other table columns value.

[Anonymous]

Hi,

I need your help!

I have table 1 with start and end time.

StartTime	EndTime
1/1/2019 9:00	1/1/2019 11:00
1/1/2019 9:00	1/1/2019 13:00
1/1/2019 10:00	1/1/2019 11:00
1/1/2019 11:00	1/1/2019 14:00
1/1/2019 14:00	1/1/2019 16:00
1/1/2019 17:00	1/1/2019 21:00
1/1/2019 22:00	1/2/2019 0:00
1/2/2019 2:00	1/2/2019 6:00
1/2/2019 5:00	1/2/2019 10:00
1/2/2019 11:00	1/2/2019 12:00

I want to create table with timeline column based on earliest Start time(1/1/2019 9:00) and latest End time(1/2/2019 12:00).

Table2 TimeLine column like this

Start with table 1 Earliest Start time and increase 1 hour and finish at table 1 latest End time.

Table2

TimeLine

1/1/2019 9:00

1/1/2019 10:00

1/1/2019 11:00

1/1/2019 12:00

1/1/2019 13:00

1/1/2019 14:00

1/1/2019 15:00

1/1/2019 16:00

1/1/2019 17:00

1/1/2019 18:00

1/1/2019 19:00

1/1/2019 20:00

1/1/2019 21:00

1/1/2019 22:00

1/1/2019 23:00

1/2/2019 0:00

1/2/2019 1:00

1/2/2019 2:00

1/2/2019 3:00

1/2/2019 4:00

1/2/2019 5:00

1/2/2019 6:00

1/2/2019 7:00

1/2/2019 8:00

1/2/2019 9:00

1/2/2019 10:00

1/2/2019 11:00

1/2/2019 12:00

Thanks advance!:)

[parry2k · Accepted solution]

@Anonymous  solution attached, i hope this is what you need?

[Anonymous]

Wow! Thank you for your help. it is exactly I wanted the answer.

I have a question of your file. If I use your data medeling, I just copy Advanced Editor and change some talbe/column name and apply my modeling. Is it ok?

[parry2k]

@Anonymous good to hear that you have the solution. Please feel free to change as per your need. Have fun and never hesitate to reach out if need more help.

Cheers!!