Hi everyone,
i have the following problem.
I would like to make pairs of the following form:
| Arrival |
Stage |
Departure |
| 02/11/2021 13:31:27 |
1. Process |
02/11/2021 14:11:38 |
| 02/11/2021 14:12:02 |
1. Process |
02/11/2021 14:12:03 |
| 02/11/2021 14:18:27 |
2 Distribucion |
02/11/2021 14:18:28 |
| 02/11/2021 14:50:42 |
1. Process |
02/11/2021 15:03:51 |
| 02/11/2021 15:10:41 |
2 Distribucion |
02/11/2021 15:10:42 |
There are some pairs that can be like this:
| Arrival |
Stage |
Departure |
| 02/11/2021 13:31:27 |
1. Process |
02/11/2021 14:11:38 |
| 02/11/2021 14:12:02 |
1. Process |
02/11/2021 14:12:03 |
| 02/11/2021 14:18:27 |
2 Distribucion |
02/11/2021 14:18:28 |
| 02/11/2021 14:50:42 |
2. Verification |
02/11/2021 15:03:51 |
| 02/11/2021 15:10:41 |
3. Proceso |
02/11/2021 15:10:42 |
These are other stages
|
X |
|
These are other stages
|
X |
|
| 02/11/2021 14:50:42 |
2. Verification |
02/11/2021 15:03:51 |
| 02/11/2021 15:10:41 |
3. Proceso |
02/11/2021 15:10:42 |
What I want to do is this:
| Arrival |
Stage |
Departure |
Pair |
| 02/11/2021 13:31:27 |
1. Process |
02/11/2021 14:11:38 |
1 |
| 02/11/2021 14:12:02 |
1. Process |
02/11/2021 14:12:03 |
|
| 02/11/2021 14:18:27 |
2 Distribucion |
02/11/2021 14:18:28 |
2 |
| 02/11/2021 14:50:42 |
2. Verification |
02/11/2021 15:03:51 |
1 |
| 02/11/2021 15:10:41 |
3. Proceso |
02/11/2021 15:10:42 |
1 |
These are other stages
|
X |
|
|
These are other stages
|
X |
|
|
| 02/11/2021 14:50:42 |
2. Verification |
02/11/2021 15:03:51 |
2 |
| 02/11/2021 15:10:41 |
3. Proceso |
02/11/2021 15:10:42 |
2 |
Currently she is doing couples but when two stages appear like those of:
| 02/11/2021 14:50:42 |
2. Verification |
02/11/2021 15:03:51 |
1 |
| 02/11/2021 15:10:41 |
3. Proceso |
02/11/2021 15:10:42 |
1 |
| 02/11/2021 14:50:42 |
2. Verification |
02/11/2021 15:03:51 |
2 |
| 02/11/2021 15:10:41 |
3. Proceso |
02/11/2021 15:10:42 |
2 |
For these cases, the couple is not performing.
Or if it is done but does not separate them with 1 and 2 but takes it as a single pair
