• 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
    • 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