Easyflow docs
  • 🚩Introduction
  • Automation
    • 🚀Get Started
    • 🤖Workflows
    • ⚡Run & Invoke
      • Manual
      • Triggers
      • Scheduler
      • WebHook (Instant)
      • Rest API endpoint
      • Transactional vs Queue
      • Online \ Offline
    • 🎶Workflow orchestration
      • Step operations
      • Step configuration
      • Data mapping
    • 👣Steps and conditions
      • Multi steps
      • Parallel steps
      • Conditions
      • Loop & iteration
    • 🎲Dynamic content
      • Variables
      • Function expressions
    • 📦Schema
      • Schema builder
      • Auto schema detection
      • Use cases
    • 🐞Debugging
  • Visualisation
    • 🚀Get Started
    • 🧮Visual designer
      • Dashboard designer
      • Card designer
    • 🔌Datasources
      • Partner connectors
      • Existing connections
      • URL (CSV or JSON)
      • Data pipeline (Flow)
      • Data-blocs
      • Push to visualiser
    • 🎻Data pivoting
    • 📈Chart types
    • 🎨Customisation
      • Card appearance
      • Theme & branding
    • 🤝Preview & sharing
      • URL share
      • Scheduled snapshots
      • Send to TV
      • Preview mode
    • ⌛Refresh settings
  • Data Pipeline
    • 🚀Get Started
    • 🗞️Pipeline (ETL)
    • ⚡Automated runs
    • 🌻Transformation
      • Average by group
      • Change text casing
      • Clean data
      • Combine columns
      • Combine tables
      • Compare dates
      • Convert array of objects to array of arrays
      • Count by group
      • Extract text from column
      • Fill in blanks
      • Filter rows
      • Find and replace
      • Find maximum by group
      • Find min/max per row
      • Find minimum by group
      • Flatten rows
      • Format dates
      • Format numbers
      • Insert date & time column
      • Insert growth rate column
      • Insert if/else column
      • Insert if/else blank column
      • Insert math column
      • Insert row numbers
      • Insert rows
      • Insert running total column
      • Insert text column
      • Limit rows
      • Merge duplicate rows
      • Pivot columns
      • Remove duplicate rows
      • Rename columns
      • Select columns
      • Reorder columns
      • Sort rows
      • Split column
      • Stack tables
      • Sum by Group
      • Unpivot columns
      • Use regex
    • 🕶️Preview results
    • 🎻Orchestration
    • 📤Output
      • For Google Datastudio
      • For Easyflow visualisation
      • Array of arrays
      • Array of objects
  • Connectors
    • 🚀Get Started
    • 🌟Built-in Connectors
      • CSV
      • Data bloc
      • Data mapper
      • Delay (Wait)
      • HTTP
      • For Loop (Iteration)
      • Functions
        • Array functions
        • Conditions
        • Convertors
        • General functions
        • Date & Time
        • Filters
        • Math functions
        • Object functions
        • Operators
        • Text functions
      • Receive emails | IMAP
      • RSS
      • Send emails | SMTP
      • SQL Syntax
      • Trasform
      • Variables Setter
      • WebHook
      • Workflow (Sub flow)
    • 🌠Partner connectors
  • System
    • 👫Teams
    • 🙂Profile
    • 🧑‍💻Monitoring
    • 🔋Account Usage
    • 💵Billing and Pricing
Powered by GitBook
On this page
  • Input/output
  • Settings

Was this helpful?

  1. Data Pipeline
  2. Transformation

Select columns

PreviousRename columnsNextReorder columns

Last updated 2 years ago

Was this helpful?

The Select columns step keeps or removes whichever columns you choose from your dataset.

Input/output

In our input data below, there are five columns: "Product", "Color", "Size", "Quantity" and "Total".

After using the Select columns, it produces an output of the two columns selected to keep: "Product" and "Size".

Settings

Pick the dataset, then select from "Select Action" dropdown the Keep columns or Remove columns options,

then in "Columns" add the list columns name or indexes per order separated by comma. Example: col1,col4,col3... or 0,4,3...

🌻