i have a Timekey in my main table which is set up for each seconds. i.e., the values will be from 1 to 86400.
Now, i have to join this table with another table that has timekey set up for each hour i.e., from 1 to 24.
How can i aggregate the Timekey in my main table to have values for each hour (1 to 24) so that i can join the two tables and have meaningful values. please help
