Help Centre

Operations index
Define table
Detect headers

Convert the first row(s) of the input data into column headers.
Script operation

Splits the table according to values in a defined column.
Combine columns

Create a new column with the content of multiple other columns.
Script operation
Number format

Change values to a regional number format, e.g. 100,000 to 100.000
Script operation
Remove rows

Remove rows with specific column values, typically insignificant rows such as headers and footers.
Fill Down

Replace blanks with the value from the row above.
Map column headers

Map column names from their source name to a desired name.
Add, remove or reorder columns.
Map values

Map values from their source value to a desired value.
Append file name

Create a new column with the name of the file from which the row originated. This is useful when the file name contains important information such as reporting date, and can be used for tracing data errors.
Script operation

Add a column of values calculated from other columns in your dataset.
Extract (Regex)

Extract data from a column using regular expressions

Aggregate rows according to the values in a selected column. Define the aggregation method (Sum, Min, Max, Mean). Creates a new output of the aggregated data.
Swing Down

Transpose the headers of selected columns into rows in a new column.
Date Cleanse

Convert incoming dates to Basic ISO format for use in Quantemplate. Remove invalid dates and replace with blanks. Capture invalid dates in a Validation Report.
Date Output

Convert dates from Basic ISO format to other formats for use in downstream systems outside Quantemplate.

Configure data validation rules and actions.

Add a script operation to insert a custom script
Contact Quantemplate support for assistance with scripting.
Script operation
Offset Column

Script to take the contents of a column and repeat it in a new column, offsetting the values by one row.
Stack Grids

Script to split a file vertically on selected columns, stacking each slice horizontally.