Functions

• Function References Documentation

  Comprehensive documentation of data transformations that can be used within WorkflowsFew readers

Widgets

• Widgets Reference Documentation

  Comprehensive documentation on widgets that can be used within WorkflowsFew readers

Nodes

• Get Data Node

  Use the Get Data node to select the data sources you want to transform in your Workflow. Eligible data sources can include raw data from Integrations or transformed data from other Workflows.Few readers

• Save Data Node

  Make the results of your workflow available for other workflows or use them in dashboards by connecting the appropriate nodes with a Save Data node.Few readers

• Select Columns Node

  Use the Select Columns node to choose a subset of columns from the input table. You can choose whether the selected columns are kept or excluded with the select mode dropdown.Few readers

• Join Node

  Use the Join node to merge together two tables that share a common column (e.g. an internal id or email address).Few readers

• Group and Aggregate Node

  Use the Group and Aggregate node to generate summary statistics for groups of rows. You'll start with the group columns, which are used to place the rows from the input table into groups.Few readers

• Union Node

  Use the Union node to append data from multiple input nodes with the same schema.Few readers

• Except Node

  Use the Except node to remove rows that exist in a second table that has the same schema.Few readers

• Sort Node

  Use the Sort node to sort the rows based on column values. For each column, you can decide if rows should be sorted in ascending (default) or descending order.Few readers

• Limit Node

  Use the Limit node to limit the output to a fixed number of rows.Few readers

• Filter Node

  Use the Filter node to filter rows from the input node by a condition. Rows are kept if the condition is true. If you provide multiple conditions, rows are kept if all of them are true.Few readers

• Distinct Node

  Use the Distinct node to remove duplicate rows. By default, all the columns will be used to compare rows, to decide if there are duplicate values.Few readers

• Pivot Node

  Use the Pivot node to summarize the relationship between two columns. To build a pivot table, you'll need to specify the two columns to compareFew readers

• Unpivot Node

  Use the Unpivot node to reverse data that is pivoted. Pivoted data is great for presentation, but is not a good format for data analytics. You can use the Unpivot node to combine multiple columns into separate row values.Few readers

• Intersect Node

  Use the Intersect node to only include rows that appear in all the input nodes.Few readers

• Edit Node

  Use the Edit node to transform columns using pre-defined functions. Edits are useful for common operations like basic math, manipulating strings or extracting parts of dates.Few readers

• Add Node

  Use the Add node to create new columns using pre-built functions. The behavior is identical to the edit node, except that the output creates new columns instead of replacing existing columns.Few readers

• Convert Node

  Use the Convert node to change the data type of columns, for example, turning numbers into text.Few readers

• Rename Node

  Use the Rename node to rename the columns from the input node.Few readers

• Function Node

  Use the Formula node to create new columns using spreadsheet-like formulas. You reference columns using their name, and formulas are applied automatically to all rows in the table. You have access to arithmetic operations, and a library of functions.Few readers

• Window and Calculate Node

  Use the Window and Calculate node to calculate a metric for each row, by looking at other rows in the chosen window. This node is great for calculating a 7-day moving average or cumulative sum in a certain metric.Few readers

Show more articles