Tutorials
Follow our channel for tutorials and more
Popular topics
Column mapping
Map your data sources to
a common schema
a common schema
Dates
Cleansing, transforming
and calculating dates
and calculating dates
Reconciliation
Allocate amounts from one
dataset across another
dataset across another
Type validation
Automated data type
validation checks
validation checks
Syntax and functions
Syntax reference for Calculate
and Validation operations
and Validation operations
Operations Index
Full index of operations
in Pipelines
in Pipelines
All topics
Getting started
Admin tools
Feeds
Introducing feeds
About feeds
Use cases
Partnerships
About partnerships
Create a partnership
Feeds workspace
Overview
Submissions
Subsections
Statuses
Schedules
Chain of Custody
Feeds set up
Create a feed
Connect to a pipeline
Manage submissions
Submitting data
Submit data
Resubmissions
Data versioning
Managing Feeds
Feeds repo
Organise feeds
Archive and restore
Permissions and sharing
Manage multiple feeds
Pipelines
Introducing pipelines
About pipelines
Automation features
Workspace
Overview
Flow
Run and Auto Run
Stages and operations
Pipeline history
Managing pipelines
Pipelines repo
Organise pipelines
Archive and restore
Permissions and sharing
Manage multiple pipelines
Lock Operations
Inputs and outputs
Pipeline inputs
Pipeline outputs
Run results
View, export and download outputs
Join and union
Join stage
Reconciliation
Union stage
Dates
Working with dates
Date Cleanse
Date Output
Date examples
Automap Values
About Automap Values
Using Automap Values
Waypointing
Mapping Report
Validation
Data type validation
Validate operation
Validation report
Validation corrections
Validation examples
Syntax and functions
Functions index
General functions
Date functions
Operators and syntax
Operations
Operations index
PRIMARY OPERATIONS
Calculate
Detect Headers
Map Column Headers
Map Values
Remove Rows
Validate
ADVANCED OPERATIONS
Aggregate
Append If Missing
Append Metadata
Clip From Column
Combine Columns
Date Cleanse
Date Output
Fill Down
Number Format
Number Within Groups
Offset Column
Partition
Regex
Row Number
Sort Rows
Stack Grids
Swing Down
Text Cleanse
Best practice
Data import pattern
Add original row number
Working with schemas
Populate default values
Transpose rows and columns
Performance optimisation
Workflow tips
Architecture
Troubleshooting
Updates and Legacy
Pipeline Processor versions
LEGACY DATE OPERATIONS
Add Term to Date
Date Cleansing
Duration
Extract Date
Year Quarter
Data
Analyse
Workspace
Overview
Frames
Pages
Undo and History
Using Reports
Create and manage reports
Permissions and sharing
Manage multiple reports
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