Getting started
Introduction
System requirements
Quick start guide
Reference
User Interface
Main window
Left pane
Center pane
Right pane
Log pane
Preferences window
Input
Input data
Transforms
Transform data
Calculate
Case
Chop
Clone
Cluster
Compare Cols
Concat Cols
Concat Rows
Copy Cols
Count
Cross
DateTime Format
Decode
Dedupe
Extract
Fill
Filter
Gather
Hash
Header
If
Impute
Insert
Interpolate
Intersect
Javascript
Join
Lookup
Moving
New Col
New Rows
Ngram
Num Base
Num Format
Offset
Outliers
Pad
Pivot
Remove Cols
Rename Cols
Reorder Cols
Replace
Row Num
Sample
Scale
Sequence
Slice
Sort
Split Col
Split Rows
Spread
Stack
Stamp
Stats
Substitute
Subtract
Summary
Total
Transpose
Unfill
Unique
Units
Whitespace
Output
Output data
File formats
File formats
CSV format
Excel format
Fixed width format
JSON format
HTML format
Markdown format
Plain text format
TSV format
vCard format
XML format
YAML format
Processing
Comments
Headers
Connections
Text
Dates
Numbers
Booleans
Locale
Meta Information
Column variables
Regular expressions
Fuzzy matching
Drilldown
Batch processing
Command line arguments
File name variables
.transform files
Keyboard shortcuts
Dark mode
How do I?
Add a transform between existing items
Add metadata to a dataset
Add missing data values
Add or remove a header
Change a connection
Change encoding
Clean a dataset
Convert to percentages
Duplicate a series of transforms
Dedupe a dataset
Find the difference between dates/datetimes
Handle column name/order changes in inputs
Handle datasets with many columns
Handle large datasets
Input a fixed width format file
Merge datasets
Move a .transform file
Open multiple main windows
Output nested JSON or XML
Output to Excel
Profile a dataset
Perform the same transforms on many files
Replace empty values
Run jobs on a schedule
Scrape web data
See changes from a transform
Set output file name from input file
Show whitespace
Split a dataset into multiple files
Trigger an update when an input changes
Visualize data
Write to multiple sheets of an Excel file
Expert tips
Expert tips
Support
Forum
Contact support
Report a bug
Request an enhancement