Add Columns

The Add Columns tool can be used to add a new column, based on an expression or formula.

Input, Output

Drag an Add Columns tool to your workflow canvas. Connect a downstream tabular-data output to the input of your Add Columns tool. Click it once to see the tool preview. Click it again to open and configure the tool.

Input	Output
Any single table	A single table with all original input columns and any new expression-based columns

Navigating Columns

On the right side, you will see your results table, it represents the output of the tool. On the left side, is the configuration panel. Left/right buttons control which column is selected. Column metadata for the selected column is shown underneath.

Add a New Column

To add a new column from the results table, click the dropdown in any column header, then select Insert Right or Insert Left to add a column. Alternately, you can scroll to the far-right of your results table and click the plus button.

Either selection will open the Expression Builder, near your new column. From the top controls, you may provide a name for your column and you can reposition the Expression Builder using the drag handle on the right. Under the controls is where you write your expression.

Adding derived columns is key to advancing an analysis. The Expression Builder, baked into the Add Columns tool, is ideal for this task. It's potential is capped only by your imagination (and maybe your source data).

Use Expression Builder to:

• Write an expression based on the columns from the input table, in a simple math formula (as in the example above). See a list of Expression Operators supported by AuditBoard Analytics.
• Mark an entire column a Boolean True or False.

• Tag an entire column with a Text String or a Date Time.

• Reference a Parameter on your canvas.

• Write a Function, from wide selection of functions, including: Aggregate, Conversion, Datetime, Logical, Math, Table, and Text functions.

Hint: Use Enter to save and calculate anything you have written in Expression Builder. Be sure to save your expression before exiting the Add Columns tool.