Skip to main content

Tool Palette

The tool palette is the horizontal bar at the top of the workspace where you find and add tools to your workflow.

Categories​

Tools are organized into categories, displayed as tabs:

TabIconDescription
Favorites⭐Quick access to commonly used tools
In/Out📁Data input and output tools
Preparation🔧Data cleaning and transformation tools
Join🔗Tools for combining datasets
Aggregate📊Summarization and grouping tools

Click a tab to see the tools in that category.

Available Tools​

Favorites​

The most commonly used tools for quick access:

  • Input, Output, Filter, Select, Sort, Formula, Union, Join, Summarize

In/Out​

ToolIconPurpose
Input📂Load data from files or databases
Output💾Save data to files

Preparation​

ToolIconPurpose
Filter🔍Split data based on a condition
Select✅Choose, rename, reorder, and cast columns
Sort🔢Order rows by column values
Formula🧮Create or replace calculated columns
Sample🎲Take a subset of rows
Unique🔑Remove duplicate rows

Join​

ToolIconPurpose
Union🔗Stack datasets vertically
Join🤝Combine datasets horizontally on key columns

Aggregate​

ToolIconPurpose
Summarize📊Group data and calculate aggregations
Pivot🔄Reshape data from long to wide format
Unpivot📐Reshape data from wide to long format

Adding Tools to Canvas​

  1. Navigate to the category containing the tool you need
  2. Click and drag the tool from the palette
  3. Drop it onto the canvas at the desired location

The tool is added with default configuration and is ready to be wired and configured.

Tool Colors​

Each tool category has a distinct border color to help you identify tools at a glance:

  • In/Out: Green
  • Preparation: Blue
  • Join: Purple
  • Aggregate: Orange