• 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
      • New Col
      • New Rows
      • Ngram
      • Num Format
      • Offset
      • 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
    • 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
    • Output nested JSON or XML
    • Output to Excel
    • Profile a dataset
    • Perform the same transforms on many files
    • Replace empty values
    • Scrape web data
    • See changes from a transform
    • Show whitespace
    • Split a dataset into multiple files
    • Visualize data
    • Write to multiple sheets of an Excel file
  • Expert tips
    • Expert tips
  • Support
    • Forum
    • Contact support
    • Report a bug
    • Request an enhancement