Help Centre
Login
Contact us
Integrate
Tools to harmonise
disparate data sources
Analyse
Build reports to query
and visualise your data
Popular topics
Column mapping
Map your data sources to
a common schema
Dates
Cleansing, transforming
and calculating dates
Automap values
Automatically map large numbers
of values to a reference set
Validation
Check your data against
validation rules
Syntax and functions
Syntax reference for Calculate
and Validation operations
Operations Index
Full index of operations
in Integrate
Quantemplate Developer Hub
Build tools to automatically extract data from Quantemplate using our APIs
View the documentation →
All topics
Getting started
Introducing Quantemplate
Product areas
Logging in
User profile and organisation
Video tutorials
Getting started
Exporting data
Calculated columns
Map column headers
Map values
Regular expressions
Union and join
Validation
Reusing pipelines
Permissions and sharing
Pivots
Filters
Graphs
Equations
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
Syntax and functions
Functions index
General functions
Date functions
Operators and syntax
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
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
Text and images
Text frames and styling
Working with images
Equation editor
Using the editor
Functions in Analyse
Pre/Post-Pivot
Graphs
About
Graph types