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
Lock operations
Reusing pipelines
Inputs and outputs
Pipeline inputs
Pipeline outputs
Exporting outputs
Downloading outputs
Sharing outputs
Join and Union
Join stage
Union stage
Dates
Working with dates
Date Cleanse
Date Output
Automap Values
About Automap Values
Using Automap Values
Waypointing
Mapping Report
Validation
Validate operation
Validation Report
Operations
Operations index
PRIMARY OPERATIONS
Calculate
Detect Headers
Map Column Headers
Map Values
Remove Rows
Validate operation
ADVANCED OPERATIONS
Aggregate
Append Filename
Append If Missing
Clip From Column
Combine Columns
Date Cleanse
Date Output
Fill Down
Number Format
Offset Column
Partition
Regex
Row Number
Select Columns
Stack Grids
Swing Down
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
Automap Values
Regular expressions
Union and Join
Validation
Reusing pipelines
Analyse
Pivots
Filters
Graphs
Equations
Permissions and sharing
Introducing Integrate
Example workflow
Quantemplate Integrate provides a completely flexible toolset to cleanse and harmonise your data.
Most workflows in Quantemplate follow this structure:
1. Create a pipeline
In the Integrate view,
create a new pipeline
.
2. Upload raw data
In the
inputs tab
, drag and drop your raw data files.
3. Define the data area
Use
Remove rows
to identify the data area, then define the column headers via a
Detect headers
operation.
4. Add stages and operations
Transformations
,
Joins
and
Unions
incrementally as required.
5. Run the pipeline to preview the outcome
Running the pipeline makes the results available within the
pipeline outputs
, but does not export them to your
data repo
.
6. Review outputs
Review the output data,
validation report
and
mapping reports
from the outputs tab, then
download
directly, or
export
to your data repo to share or send to
Analyse
for querying and visualisation.
Tip
Accelerate pipeline run times by disabling stage outputs which are not required for export. See
Exporting stage outputs
for details.