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.

NULL handling

  • Object Link mapping table entries with NULL values in the IN or OUT column will register the object specified in the none-NULL entry. However, no link will be added to the Object Link graph.

Examples
Object_Link_example_graph.png

[1]

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

Query

Column1 

         LINK_OBJECTS("MATERIAL"."ID")."VALUE"

Column2 

         LINK_OBJECTS("MATERIAL"."ID")."INCOMING"

Column3 

         LINK_OBJECTS("MATERIAL"."ID")."OUTGOING"

Input

Output

ACTION

OUT : string

IN : string

DESCRIPTION : string

DURATION : int

'Olive oil'

'Dough'

'mix'

3

'Flour'

'Dough'

'mix'

3

'Egg'

'Dough'

'mix'

3

'Vegetables'

'Veggie pasta'

'steam'

10

'Chicken'

'Chicken pasta'

'roast'

25

'Chicken'

'Egg'

'lay'

null

'Egg'

'Chicken'

'hatch'

null

'Egg'

'Hard boiled eggs'

'boil'

7

'Egg'

'Hard boiled eggs'

'boil'

8

'Dough'

'Dough'

'knead'

5

'Dough'

'Pasta'

'rest & shape'

30

'Pasta'

'Veggie pasta'

'cook'

2

'Pasta'

'Chicken pasta'

'cook'

2

MATERIAL

ID : string

CATEGORY : string

QUANTITY : float

UNIT : string

PRICE : float

'Coal'

null

10.0

'kg'

1.0

'Olive oil'

'raw ingredients'

2.0

'tbsp'

0.08

'Flour'

'raw ingredients'

250.0

'g'

0.1

'Vegetables'

'raw ingredients'

500.0

'g'

2.3

'Chicken'

'raw ingredients'

1.0

'lbs'

6.0

'Egg'

'raw ingredients'

1.0

null

0.5

'Dough'

'intermediate goods'

400.0

'g'

1.0

'Pasta'

'intermediate goods'

400.0

'g'

3.5

'Veggie pasta'

'finished meals'

800.0

'g'

8.5

'Chicken pasta'

'finished meals'

900.0

'g'

9.5

'Hard boiled eggs'

'finished meals'

2.0

null

2.0

'Salad'

'finished meals'

500.0

'g'

6.5

Result

Column1 : string

Column2 : int

Column3 : int

'Olive oil'

0

1

'Flour'

0

1

'Vegetables'

0

1

'Chicken'

1

2

'Egg'

1

4

'Dough'

4

2

'Pasta'

1

2

'Veggie pasta'

2

0

'Chicken pasta'

2

0

'Hard boiled eggs'

2

0

[2]

LINK_OBJECTS returns values via the VALUE column access based on the entailed expression. The common table of all entailed expressions has to be a connected Object Link table. In this example the concatenation of material attributes in the second dimension keeps the MATERIAL table as the common table.

Query

Column1 

         LINK_OBJECTS("MATERIAL"."ID")."VALUE"

Column2 

         LINK_OBJECTS("MATERIAL"."QUANTITY"||"MATERIAL"."UNIT")."VALUE"

Input

Output

ACTION

OUT : string

IN : string

DESCRIPTION : string

DURATION : int

'Olive oil'

'Dough'

'mix'

3

'Flour'

'Dough'

'mix'

3

'Egg'

'Dough'

'mix'

3

'Vegetables'

'Veggie pasta'

'steam'

10

'Chicken'

'Chicken pasta'

'roast'

25

'Chicken'

'Egg'

'lay'

null

'Egg'

'Chicken'

'hatch'

null

'Egg'

'Hard boiled eggs'

'boil'

7

'Egg'

'Hard boiled eggs'

'boil'

8

'Dough'

'Dough'

'knead'

5

'Dough'

'Pasta'

'rest & shape'

30

'Pasta'

'Veggie pasta'

'cook'

2

'Pasta'

'Chicken pasta'

'cook'

2

MATERIAL

ID : string

CATEGORY : string

QUANTITY : float

UNIT : string

PRICE : float

'Coal'

null

10.0

'kg'

1.0

'Olive oil'

'raw ingredients'

2.0

'tbsp'

0.08

'Flour'

'raw ingredients'

250.0

'g'

0.1

'Vegetables'

'raw ingredients'

500.0

'g'

2.3

'Chicken'

'raw ingredients'

1.0

'lbs'

6.0

'Egg'

'raw ingredients'

1.0

null

0.5

'Dough'

'intermediate goods'

400.0

'g'

1.0

'Pasta'

'intermediate goods'

400.0

'g'

3.5

'Veggie pasta'

'finished meals'

800.0

'g'

8.5

'Chicken pasta'

'finished meals'

900.0

'g'

9.5

'Hard boiled eggs'

'finished meals'

2.0

null

2.0

'Salad'

'finished meals'

500.0

'g'

6.5

Result

Column1 : string

Column2 : string

'Olive oil'

'2tbsp'

'Flour'

'250g'

'Vegetables'

'500g'

'Chicken'

'1lbs'

'Egg'

null

'Dough'

'400g'

'Pasta'

'400g'

'Veggie pasta'

'800g'

'Chicken pasta'

'900g'

'Hard boiled eggs'

null

See also: