Help Centre

Add a column of values calculated from other columns in your dataset.

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

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

Map values from their source value to a desired value. Incorporating Automap Values.

Remove rows with specific column values, typically insignificant rows such as headers, totals and subtotals.

Configure data validation rules and actions.

Pivot, merge and aggregate rows according to the values in a selected column. Define the aggregation method (Sum, Min, Max, Mean) and validate merges are as expected.

Create a new column with the name of the file from which the row originated.

Add a column if not already present.

Remove all data before or after a column.

Create a new column combining the content of two or more other columns.

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.

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

Replace blanks with the value from the row above.

Convert values from a regional number format so they can be interpreted by Quantemplate e.g. 100.000,00 to 100000.

Splits the table according to values in a defined column.

Find and replace characters using Regular Expressions (Regex) pattern matching.

Create new table from selected columns.

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

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

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