Switch

In a selection block, there is always a key defined on which the selection (count) is based. The 'Switch' function can be used to change the key of a selection block to another key.

Drag a switch block to the worksheet and connect an input (selection) block to the switch block.


Double-click the switch block to open the settings.


Source/ Entity

First, select the source and it the entity type in which the 'key switch' will take place.

More details: Source/ Entity/ Key.

Key

Then select the new key into which you want to change.

Block template

More details: Block template.

Description

More details: Description.

Apply/ Cancel/ Save/ Calculate

The switch block is executed after the button "Calculate" is clicked.


Example

Switch from key 'email' to key 'MDB_account_id'. Ternair searches records for which the key 'email' matches the column 'email' in the selected entity type. From all corresponding records, the column 'MDB account_id' is then selected as the key value.

Video



Copyright © 2025 Ternair.