Projection
A projection node represents a relational selection (filter) combined with a projection operation. It also allows calculated attributes to be added to the output.
Procedure
- Add the Projection node onto the canvas, and connect the source data or the previous node to this node. Click the gear icon to view the settings.
- (Optional) On the Columns tab, map any columns that are not already mapped to the output target, select the column from the Mapping column. You may also remove any output columns by clicking the x icon.
- Click the Filters tab.
- Use the Expression Editor or type an expression to filter the data from the input to the output. Drag the input columns, select a function and the operators. For example, if you want to move all the records that are in Canada for the year 2017, your filter might look like this: "Filter1_input"."COUNTRY" = "Canada" AND "Filter1_input"."DATE"="2017". See the "SQL Functions" topic in the SAP HANA SQL and System Views Reference for more information about each function.
- Click Apply to return to the flowgraph.
