Sources and targets
Reads a registered file source or writes to its range.
A single block for business systems, databases, file storage and external APIs.
Creates an Excel, CSV, TXT, JSON, XML or SQLite file.
Sends emails through a configured email connection.
Sends messages and attachments through a bot.
Table structure and combination
Keeps the required fields and changes their order and names.
Builds a new table from selected columns and constant values.
Converts a wide table of periods into “period — value” rows.
Swaps the rows and columns of a table.
Combines the rows of several tables into one dataset.
Adds fields from other tables using shared keys.
Keeps the required occurrence of each key, or only keys that occur once.
Adds the measures from a single auxiliary row to every row of the main table.
Rules and transformations
Keeps rows that meet the specified conditions.
Groups rows by keys and calculates aggregates.
Adds calculations for numbers, text, dates and conditions.
Sequential cleansing and standardisation of text fields.
Recognition, normalisation and formatting of numbers and calendar values.
Rules for replacement, row rejection and stopping on quality errors.
Adds a GUID, Snowflake ID or sequential number.
Conditionally changes existing fields and adds new ones.
Adds current UBC Analytics role and user values.
Control and interaction
A user form and constant values that control execution.
Distributes rows between conditional branches, including by reference data.
Passes the entire table to several branches at the same time.
A manual user decision that activates one branch.
Continues one of the alternative branches that executed.
A review table during execution and a way to end a branch without writing.
Displays a notification or dialog during user-driven execution.
Compatibility with saved flows that upload a file at this step.
Reuse and file exchange
Copy and move files and folders between File Manager and connected storage.
Separate branches for a manual start, inbound API and Workspace button.
Start the Production versions of one or more other flows with parameters and data.
An input for a subflow or process receiving a table from another flow.
Reuse a flow as a function: an input table and a transformed output table.
A declared output returned to the calling subflow block.