Skip to main content

​
What This Node Does

The Select node lets you choose which columns to keep or remove from your dataset. Use it to reduce clutter, improve workflow performance, and show only relevant fields in your final output. [SCREENSHOT: Select node on canvas showing “10 of 45 columns selected”]

​
When to Use This Node

Use the Select node when you need to:
  • Simplify output - Show only relevant columns in final exports or dashboards
  • Improve performance - Reduce data size by removing unused columns early in workflow
  • Remove sensitive data - Exclude columns with PII or confidential information
  • Prepare for joins - Select only necessary columns before expensive join operations

​
Step-by-Step Usage Guide

1

Add Select node to canvas

2

Connect to upstream data

3

Choose Keep Selected or Remove Selected mode

Keep Selected: Check columns you want to keep, uncheck to removeRemove Selected: Check columns you want to remove, uncheck to keep[SCREENSHOT: Selection mode toggle]
4

Select columns using checkboxes

Use the search box to quickly find columns in large datasets[SCREENSHOT: Column list with search and checkboxes]
5

Preview results

​
Tips and Best Practices

Select Early: Add Select nodes right after Input to reduce data flowing through your workflow. This improves performance of all downstream nodes.
Use Search: For tables with 50+ columns, use the search box instead of scrolling. Type partial column names to quickly find what you need.
Keep ID Columns: Always keep key/ID columns even if not displayed in final output. You might need them for joins or debugging.
Remove Not Select: If you want to keep most columns and remove just 2-3, use “Remove Selected” mode instead of unchecking dozens of columns.