Calculated Field #

While working with a Workflow, you may want to add a new column that is the result of a calculation from other columns. Below we present avaliable options for you to do so.

Script #

You can add a Calculated Field using a Script Component (most often a Script Transformation).

Because only database sources return data tables with correct data types, make sure the columns used for calculation are either Integers or Floats before creating a Calculated Field this way.

Example Table

Example Script Transformation

import pandas as pd
df = INPUT_DATA[0]

if df.empty:
    df['Profit'] = 1.1
else:
    df['Profit'] = df['Sell Price (USD)'] - df['Production Cost (USD)']

OUTPUT_DATA = df

The result data table would look as follows: