• Getting started
    • Introduction
    • System requirements
    • Quick start guide
  • Reference
    • User Interface
      • Main window
      • Left pane
      • Center pane
      • Right pane
      • Preferences window
    • Input
      • Input data
    • Transforms
      • Transform data
      • Case
      • Chop
      • Clone
      • Compare Cols
      • Concat Cols
      • Concat Rows
      • Copy Cols
      • Count
      • Cross
      • Date Format
      • Dedupe
      • Extract
      • Fill
      • Filter
      • Gather
      • Header
      • If
      • Insert
      • Interpolate
      • Intersect
      • Javascript
      • Join
      • Lookup
      • New Col
      • Num Format
      • Pad
      • Pivot
      • Remove Cols
      • Rename Col
      • Rename Cols
      • Reorder Cols
      • Replace
      • Row Num
      • Sample
      • Slice
      • Sort
      • Split Col
      • Split Rows
      • Spread
      • Stack
      • Stamp
      • Stats
      • Substitute
      • Subtract
      • Summary
      • Total
      • Transpose
      • Trim
      • Unique
      • Whitespace
    • Output
      • Output data
    • File formats
      • File formats
      • CSV format
      • Excel format
      • Fixed width format
      • JSON format
      • HTML format
      • Markdown format
      • TSV format
      • vCard format
      • XML format
      • YAML format
    • Comments
    • Headers
    • Connections
    • Text
    • Dates
    • Numbers
    • Meta Information
    • Column variables
    • Regular expressions
    • Batch processing
    • Command line arguments
    • .transform files
    • Keyboard shortcuts
  • How do I?
    • Add a transform between existing items
    • Add or remove a header
    • Change a connection
    • Change encoding
    • Duplicate a series of transforms
    • Dedupe a dataset
    • Find the difference between dates/datetimes
    • Handle column name/order changes in inputs
    • Handle large datasets
    • Input a fixed width format file
    • Merge datasets
    • Move a .transform file
    • Output nested JSON or XML
    • Output to Excel
    • Perform the same transforms on many files
    • Write to multiple sheets of an Excel file
  • Support
    • Forum
    • Contact support
    • Report a bug
    • Request an enhancement