How to create new data fields using data from other columns in Supervisor.
You can add calculated columns before or after loading the data.
To add a new column click on the Column Name field in the empty row at the bottom of the column definition table.
First enter the name of the new fields and select the correct mapping type from the drop down menu.
Enter the formula in the expression column.
Scripts can be used to define expressions.
Once you have entered the formula click on the Reload Data button.
If you want to make changes to the expression you can do this either in the table itself or in the Loader tab.
To update the field right click on the column definition table and select Apply Column Changes from the menu.