Insert math column
The Insert math column step executes a math equation on each row of data. This step functions similarly to writing a formula in a new Excel column.
Our input data is a list of sales orders, we will use the "SalesAmount" by "TaxAmt" columns from it.
After connecting the data into this step, it produces the output of a new column "Multiply" that shows the result of Multiplying "SalesAmount" by "TaxAmt" columns.
Pick the dataset.
Type the "New column" name, this column will be appended into the table.
Type the "Column to calculate".
Select "Calculate with" another column or custom value.
If another column is selected, type column name in the "Value" column,
If custom value is selected, type the custom value in the "Value" column.
Insert math column
Input/output
Our input data is a list of sales orders, we will use the "SalesAmount" by "TaxAmt" columns from it.
After connecting the data into this step, it produces the output of a new column "Multiply" that shows the result of Multiplying "SalesAmount" by "TaxAmt" columns.
Settings
Pick the dataset.
Type the "New column" name, this column will be appended into the table.
Type the "Column to calculate".
Select "Calculate with" another column or custom value.
If another column is selected, type column name in the "Value" column,
If custom value is selected, type the custom value in the "Value" column.
Updated on: 20/09/2022
Thank you!