Introduction
Basic concepts
Technical implementation
ETL and Data Hub
Tutorial and implementation guide
Prerequisites
Starting the examples
Debug and troubleshoot
JSON format
Common step properties
Steps
Grouping and deduplicating
Filtering
Logical operators
Comparison and other operators
Custom filtering
Mapping
Single column
Multiple columns
Defining aggregations
Fixed value
Auto value
Transformed value
Regular expression match
Switch-case statement
Custom SQL statement
Advanced topics
Fallback columns
Union mapping
Arbitrary column types
Inferring remaining columns
Compacting values
Joining
Cell merging
Overriding cell merging strategy
Order of joining
Tables priority
Wildcard joining
Column selection
Enriching
Look-up values
Split look-up
Look-up keys
Fallback
Consolidating look-up targets
Advanced deduplicating
Using MaxValue and MinValue strategy
Splitting
Chaining steps
Optional and required tables
Programmability
SQL environment
Creating reusable scripts
Extra functions
Additional Information