Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Aldemarprins4
Contributor III
Contributor III

PAIRS

 
 

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

 

0 Replies