Forum Discussion
How do i create a column with the Crew name based on Date_Time ?
I have the following table x 600k rows | Item ID | Qty Picked | Date Time | Crew Name | ABC123 4 7/17/2022 2:05:16 PM ? 123DEF 9 7/17/2022 7:05:16 PM ? 456XYZ 6 87/18/202...
lbendlin
Super User
Super UserUse an external dates/calendar table that includes your crew schedules. Looks like that table needs to be set at half day granularity.
Thank you for your response.
I already have a DATE table on my schema, i would need to create a new one right?
So it would be like...Year -> Month -> Day -> Half day -> Hour -> Minute -> Second, a column for each one
i would have to add the crew name to the date manually then, right?
it is complicated to get it add it dynamically.
Thanks.
- lbendlin
it would be like...Year -> Month -> Day -> Half day
No need to go deeper.