Forum Discussion
Solved
Shift ID lookup
Hello! I am trying to create a new column in my whse_tran table (first screenshot) with SHIFT_ID assigned to every transaction (row) based on a shift_sched table (secondscreenshot). Shift ID is dete...
Filter shift_sched for START_TIME between SHIFT_START and SHIFT_END and take the (max) SHIFT_ID corresponding to that filtered table.
MAXX ( FILTER ( shift_sched, shift_sched[SHIFT_START] <= whse_tran[START_TIME] && whse_tran[START_TIME] < shift_sched[SHIFT_END] ), shift_sched[SHIFT_ID] )
Filter shift_sched for START_TIME between SHIFT_START and SHIFT_END and take the (max) SHIFT_ID corresponding to that filtered table.
MAXX (
FILTER (
shift_sched,
shift_sched[SHIFT_START] <= whse_tran[START_TIME]
&& whse_tran[START_TIME] < shift_sched[SHIFT_END]
),
shift_sched[SHIFT_ID]
)
Perfect!!! Thank you so very much, Alexis!!!!
