Skip to main content

Celonis Product Documentation

LINK_OBJECTS
Description

Warning

To use this feature, Object Link needs to be configured with Object Link in the data model.

The LINK_OBJECTS operator creates a new table containing all rows of the input table that are part of the Object Link graph.

The LINK_OBJECTS operator creates a new table that contains all objects of the input column that are part of the Object Link graph. For each object, the count of outgoing and incoming links is calculated and saved in additional columns of the table. The result table is joined N:1 to the input table.

Syntax
 LINK_OBJECTS( input_table.column )[.COLUMN]

  • input_table.column specifies the table and output column of the connected table.

  • If COLUMN is set, it will specify the return value of the output. Otherwise the table is returned. There are three available columns with the names VALUE, OUTGOING and INCOMING:

    • VALUE returns the corresponding value of this object that is specified in the input column.

    • OUTGOING returns the count of outgoing links of this object.

    • INCOMING returns the count of incoming links of this object.

Examples

[1]

LINK_OBJECTS returns all objects and all link counts of the given input column.

Object_Link_Acyclic_Scenario.png

Query

Column1 

         LINK_OBJECTS("Case"."ID")."VALUE"

Column2 

         LINK_OBJECTS("Case"."ID")."OUTGOING"

Column3 

         LINK_OBJECTS("Case"."ID")."INCOMING"

Input

Output

Case

ID : string

OBJ_ATTR : int

'G'

4

'H'

4

'E'

3

'F'

4

'B'

1

'C'

2

'D'

3

'A'

0

'J'

null

'I'

5

MAPPING

OUT : string

IN : string

'F'

'G'

'D'

'G'

'B'

'C'

'C'

'D'

'E'

'G'

'D'

'F'

'C'

'E'

'E'

'H'

'A'

null

null

'I'

Result

Column1 : string

Column2 : int

Column3 : int

'G'

0

3

'H'

0

1

'E'

2

1

'F'

1

1

'B'

1

0

'C'

2

1

'D'

2

1

'A'

0

0

'I'

0

0

[2]

LINK_OBJECTS returns the value of the specified input column when VALUE is used as the output column type. LINK_OBJECTS returns the same result table if the input table is the same.

Query

Column1 

         LINK_OBJECTS("Case"."ID")."VALUE"

Column2 

         LINK_OBJECTS("Case"."OBJ_ATTR")."VALUE"

Input

Output

Case

ID : string

OBJ_ATTR : int

'A'

0

'B'

1

'C'

2

'D'

3

'E'

3

'F'

4

'G'

4

'H'

4

'J'

null

MAPPING

OUT : string

IN : string

'A'

null

'B'

'C'

'C'

'D'

'C'

'E'

'D'

'F'

'D'

'G'

'E'

'G'

'E'

'H'

'F'

'G'

Result

Column1 : string

Column2 : int

'A'

0

'B'

1

'C'

2

'D'

3

'E'

3

'F'

4

'G'

4

'H'

4

See also: