Page History
...
Follow the instructions below to configure an aggregate a calculated field step:
- Expand the Transformation Steps button on the left side of the Transformation Flow builder, to view a list of transformation steps.
- Drag the Calculated Field step from the list of transformation steps.
- Connect this step to the previous step in the flow. On doing so, it will become configurable.
- Click on Add Item.
- Use the popup to create a calculated field.
- Update the name of the calculated field.
- Define your calculation using the buttons at the bottom of the window, for example:
- Search for the Sum Invoiced Amount field in the -- Select Field -- drop down list and click on it to add it to the formula box.
- Press the minus ( – ) button.
- Search for the Sum Cost of Camp field and add it to the formula.
- You will now have Invoiced Amount - Cost.
- Test your calculation by using the Validate button. (An error will appear if it is invalid.)
- If the calculation is valid, click Save. The data preview panel will display a new column field for the result.
- The step's configuration panel will show the newly created calculated field.
You may also edit or delete a calculated field through here.
...