Resources | Queries | Loops |
Switches | Expressions |
Operation Type | Editor | Description |
Expressions | Expression Operation Editor | Provides the name given to the expression and an editable text field that you can use to type your valid expression syntax. |
Loops | Loop Iterator Editor | Provides the name given to the loop. You can add levels, define item filters, and use the arrows to arrange the nesting of the levels. |
Queries | Query Editor | Provides a complex visual modeling tool with three tabs to help you define the query used within your transform. |
Resources | Invoke Resource Operation Editor | Provides the name of the resource, the path to the resource in Studio, and a button that can be used to navigate through a Studio resource tree of valid resources for selection. |
Switch | Switch Case Editor | You can use the Switch operation with one or more pairs of expressions. The Switch function evaluates each pair of expressions, and returns the result corresponding to the first boolean expression in the list that evaluates to True. |
Cast | Choose Data Type | You can use the CAST function converts a value from one data type to another. |
Union | There is no editor for this operation. The operation is created with two inputs and one output that you can use to connect the items that you want to union. Use to combine the result sets of two or more items in your transform. All the source inputs must have the same data type. Union removes duplicate rows between the items that are input. |