PAIRS - Qlik Community - 1874989

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

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