Add Column
What is the ‘Add Column’ task?
The ‘Add Column’ task can be used to append a new column to a data table. The column can either be blank, contain a default value, or contain numerical or text calculations.
How to use the ‘Add Column’ task?
The important fields in the ‘Add Column’ task are
- Select Table
Use this dropdown menu to select the table in which you would like to add a column.
- New Column Name
Use this field to type in the name of the new column in the output table.
- Function
Use this dropdown menu to select the values in the new column. The values can either be blank, or contain a default value, or contain numerical or text calculations.
- Select Column(s)
Use this dropdown menu to select the columns on which the function will act.
- Format
Use this dropdown menu to indicate the format of the new column. You may select a numerical, or date, or currency, or text format.
- Apply to Group
Use this checkbox to indicate if you would like to limit the calculation to some groups of columns only. Once selected, you can also select the group of columns to which the calculations will apply.
How to use the ‘Filter Options’ section in the ‘Add Column’ task?
The ‘Filter Options’ section in the ‘Add Column’ task can be used to modify features of the output table.
More information about this section is available here.
How to use the ‘Define Output Table’ and the ‘Output Options’ sections in the ‘Add Column’ task?
The ‘Output Options’ section in the ‘Add Column’ task can be used to modify features of the output table. The fields related to this section become visible on selecting the ‘Output Options’ checkbox.
More information about this section is available here.
