Using Multiple and Dynamic Switch Columns

This topic introduces how to use multiple and dynamic Switch Columns.

1. Developers can use two or more consecutive Switch Column elements:

In this case, the operations will be conducted sequentially, based on their arrangement from top to bottom in the element tree. So, after the first Switch Column is applied, rows that may have been changed by it will be evaluated bythe second Switch Column.

2. The Switch Column element also has an Include Condition attribute:

If the value of this attribute is left blank or contains a formula that evaluates to True, the element is applied to the datalayer. If the value evaluates to False, the element is ignored and does not affect the datalayer. This powerful feature allows developers to dynamically determine if the datalayer will be altered or not.