我有一张桌子看起来是这样的
| event_d | event_lcl_ts | location_id | event_code | container_id |
|---|---|---|---|---|
| 4/6/24 | 2024-04-06T10:19:32.133+00:00 | 1 | PUTAWAY | asdjhdf-323 |
| 4/6/24 | 2024-04-06T21:52:35.019+00:00 | 1 | RECEIVE | asdjhdf-323 |
| 4/7/24 | 2024-04-07T00:13:17.496+00:00 | 1 | PUTAWAY | asdjhdf-323 |
| 4/7/24 | 2024-04-07T12:35:54.766+00:00 | 1 | RECEIVE | asdjhdf-323 |
| 4/7/24 | 2024-04-07T16:27:13.245+00:00 | 1 | PUTAWAY | asdjhdf-323 |
| 4/8/24 | 2024-04-08T22:56:19.038+00:00 | 1 | RECEIVE | asdjhdf-323 |
| 4/9/24 | 2024-04-09T00:19:47.575+00:00 | 1 | PUTAWAY | asdjhdf-323 |
| 4/10/24 | 2024-04-10T20:44:12.190+00:00 | 1 | RECEIVE | asdjhdf-323 |
| 4/11/24 | 2024-04-11T01:14:45.466+00:00 | 1 | PUTAWAY | asdjhdf-323 |
| 4/11/24 | 2024-04-11T10:14:12.709+00:00 | 1 | RECEIVE | asdjhdf-323 |
| 4/11/24 | 2024-04-11T12:57:11.640+00:00 | 1 | PUTAWAY | asdjhdf-323 |
我正在try 创建一行，其中显示接收容器然后收起时的时间戳，该时间戳基于event_code.此数据的一个警告是，根据提取的数据的时间范围，在某些情况下，PUTAWAY事件将被填充，而没有其之前的RECEIVE事件.也可能存在PUTAWAY事件在最近的RECEIVE事件中尚未发生的情况.
在这种情况下，理想输出是这样的:
| container_id | receive_timestamp | putaway_timestamp | location_id |
|---|---|---|---|
| asdjhdf-323 | 2024-04-06T21:52:35.019+00:00 | 2024-04-07T00:13:17.496+00:00 | 1 |
| asdjhdf-323 | 2024-04-07T12:35:54.766+00:00 | 2024-04-07T16:27:13.245+00:00 | 1 |
| asdjhdf-323 | 2024-04-08T22:56:19.038+00:00 | 2024-04-09T00:19:47.575+00:00 | 1 |
| asdjhdf-323 | 2024-04-10T20:44:12.190+00:00 | 2024-04-11T01:14:45.466+00:00 | 1 |
| asdjhdf-323 | 2024-04-11T10:14:12.709+00:00 | 2024-04-11T12:57:11.640+00:00 | 1 |
如何在忽略或过滤RECEIVE之前可能有PUTAWAY个事件的情况时做到这一点？在这种情况下-第一行.谢谢！