Use the Expression Editor
The Expression Editor is available in the Projection and Aggregation nodes.
Context
The Filter tab is the same in the Projection and Aggregation nodes, and is where you can use the full Expression Editor. An expression is either a mathematical calculation (sum of column1 and column5), or a way of separating data that meets the criteria of a value (product is less than $50).
Procedure
- Click Filters tab to view the columns and the available functions.
- Select the columns that you want to use in your expression. You can drag and drop the column names from the list and place it in the center of the screen.
- Select one of the available functions from the categories in the Functions pane. See the "SQL Functions" topic in the SAP HANA SQL and System Views Reference for more information about each function.
- Click or type any operators and values to complete the expression.
