🧙Transform

Table transformation may be as simple as using the Select Columns tool to retain or omit a column. However, many transform tools, offer spreadsheet-style formula entry. Edit Columns lets you write a formula -- and get a new calculation. The Filter tool splits rows into True/False outputs, based on your criteria. Pivot will allow you to aggregate and summarize a table by its columns.

Add Columns

Add new expression-based columns, by writing a quick formula

Edit Columns

Rename, retype, and reformat columns, provide metadata

Select Columns

Select Columns allows you to keep or drop selected columns from a table.

Filter

Select records from a table based on row criteria

Sort

Reorder a table based on row values

Pivot

Aggregate the values in a table

Unpivot

Convert column values into rows

Deduplicate

Remove duplicate values in a column

Python

Allows for custom Python code to be executed against tables and objects inside an AuditBoard Analytics Workflow. One can ingest any number of sources and output any number of objects.