Help Centre
Login
Contact us
GETTING STARTED
Introducing Quantemplate
Product areas
Logging in
User profile and organisation
INTEGRATE
Introducing integrate
About Integrate
Example workflow
Workspace
Overview
Stages and operations
Run Log
Pipeline history
Managing pipelines
Create and name
Organise and duplicate
Archive and restore
Permissions and sharing
Reusing pipelines
Inputs and outputs
Pipeline inputs
Pipeline outputs
Exporting outputs
Downloading outputs
Sharing outputs
Join and Union
Join stage
Union stage
Automap Values
About Automap Values
Using Automap Values
Waypointing
Mapping Report
Validation
Validation operation
Validation Report
Operations
Operations index
DEFINE TABLE
Detect Headers
Clip After Column
Partition
Combine Columns
CLEANSE
Number Format
Remove Rows
Fill Down
MAP
Map Column Headers
Map Values
ENRICH
Append File Name
Append if Missing
Calculate
Extract (Regex)
TRANSFORM
Aggregate
Select Columns (Project)
Swing Down
DATES
Working with dates
Date Cleanse
Date Output
SCRIPTS
Offset Column
Stack Grids
Syntax and functions
Functions index
General functions
Date functions
Operators and syntax
Updates and legacy
Pipeline Processor versions
LEGACY DATE OPERATIONS
Add Term to Date
Date Cleansing
Duration
Extract Date
Year Quarter
DATA
About datasets
Managing your datasets
Creating, uploading and naming datasets
Sharing datasets
Dataset Processor versions
ANALYSE
Workspace
Overview
Frames
Pages
Undo and history
Using reports
Create and manage reports
Permissions and sharing
Using data in reports
Download and print
Pivot tables
About
Pivot interface
Create a pivot
Filtering
Number formatting
Table formatting
Aggregation
Totals
Equation editor
Using the editor
Functions in Analyse
Pre/post-pivot
Graphs
About graphs
Graph types
Text and images
Text frames and styling
Working with images
TUTORIALS
Integrate
Getting started with pipelines
Exporting data
Calculated Columns
Map Column Headers
Map Values
Regular expressions
Union and Join
Validation
Reusing pipelines
Analyse
Pivots
Filters
Graphs
Equations
Permissions and sharing
Operations index
Define table
Detect headers
Convert the first row(s) of the input data into column headers.
Script operation
Partition
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
Cleanse
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
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.
Enrich
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
Calculate
Add a column of values calculated from other columns in your dataset.
Extract (Regex)
Extract data from a column using regular expressions
Transform
Aggregate
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.
Dates
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.
Validation
Configure data validation rules and actions.
Script
Add a script operation to insert a custom script
Contact
Quantemplate support
for assistance with scripting.
Script operation
Stack Grids
Script to split a file vertically on selected columns, stacking each slice horizontally.