Moving from Alteryx

Most Alteryx workflows move tool for tool: a workflow becomes a pipeline, and each core tool has a Trinium node that does the same job. This guide maps them, and says where it is not one to one.

The ideas

In Alteryx	In Trinium
Workflow	Pipeline: nodes wired together on a canvas, run on a server.
Tool	Node.
Browse anywhere	The Data, Metadata and Messages tabs under the canvas, after a Test run.
Formula expressions	One SQL expression language, used in every node that takes a rule.
Analytic App questions, Interface tools	Parameters: values a pipeline asks for when it runs.
Batch macro over a list	A text parameter with one schedule or Flow step per value, each run on its own; a cloud file input that starts one run per file.
Standard macro	No equivalent: there are no reusable parts of a pipeline. Flows reuse whole pipelines.
In-Database tools	No equivalent. Trinium reads from the database and does the work on its own server. Database Lookup is the exception: it sends a stream's keys to the database.
Scheduler	Schedules, on a timer or when files arrive.
Saved workflow versions	Versions, Staging and Production.

Tool by tool

In/Out

Theirs	Trinium	Notes
Input Data	CSV Files, Excel Files, JSON Files, Parquet Files, XML Files, SQLite Files	CSV, Excel (.xlsx and .xls), JSON, Parquet, XML and SQLite files, plus one input node for each database, warehouse and cloud store. Not read: Avro, fixed-width text, SAS, SPSS, Access, .hyper and .yxdb files.
Output Data	CSV File, Excel Report, JSON File, Parquet File, SQLite File	Plus one output node for each database, warehouse and cloud store. Excel output writes a new one-sheet workbook.
Text Input	Text Input
Browse	No node	No node needed: after a Test run, the Data, Metadata and Messages tabs under the canvas show what every node produced.
Directory	List Files	Lists a folder in S3, Azure Blob Storage, Google Cloud Storage or SFTP.
Date Time Now	No node	Use now() or current_date in a Formula, or the ${date} token in any setting.

Preparation

Theirs	Trinium	Notes
Auto Field	No node	No equivalent. Columns keep the types their source declares, and Manage Columns changes a type by hand.
Data Cleanse Pro, Data Cleansing	Data Cleanse
Filter	Filter, Route	Route sends rows down as many as ten named branches, first match wins.
Formula	Formula	Expressions are written in SQL.
Multi-Field Formula	Formula Multi-Field
Multi-Row Formula	Formula Multi-Row	SQL window functions: values from earlier and later rows, running totals and ranks. A formula that refers to its own previous result is not supported.
Generate Rows	Generate Rows	Generates a sequence of numbers or dates. It has no input, so expanding each incoming row into several takes a few nodes.
Record ID	Record ID
Sample, Random % Sample	Sample	First, last or every Nth row, a 1-in-N random chance per row, or exactly N random rows. There is no per-group sample.
Rank, Tile	Formula Multi-Row	Window functions such as rank() and ntile().
Select	Manage Columns	Keep, drop, rename, reorder and retype columns.
Sort	Sort
Unique	Unique

Join

Theirs	Trinium	Notes
Append Fields	Append Fields
Find Replace	Find & Replace
Fuzzy Match	Fuzzy Match
Join	Join	Left only, matched and right only, each on an output of its own.
Join Multiple	Join Multiple
Union	Union	Columns are matched by name or by position.

Parse

Theirs	Trinium	Notes
DateTime	DateTime
RegEx	RegEx
Text To Columns	Text to Columns	Splits into columns or into rows.
XML Parse	XML	Records are found by path; XPath is not supported.

Transform

Theirs	Trinium	Notes
Count Records	Summarize	A count in Summarize.
Cross Tab	Cross Tab
Running Total	Formula Multi-Row	A running sum window.
Summarize	Summarize	Fourteen aggregates, each with an optional condition. Not available: mode, longest and shortest, product, and the finance actions.
Transpose	Transpose
Weighted Average	Formula, Summarize	Multiply in a Formula, then sum and divide in Summarize.

Developer

Theirs	Trinium	Notes
Block Until Done, Control Container	No node	No ordering inside a pipeline, where every node runs at once. Split the work into pipelines and run them in order with a Flow.
Download	File from URL, REST API (Read)	File from URL reads a CSV, JSON, Parquet, Excel or XML file at a link; REST API (Read) pages through a JSON API.
Dynamic Input	Database Lookup	Database Lookup sends a stream's keys to a database table. The file and cloud inputs read several files at once and combine them.
Dynamic Rename	Dynamic Rename
Dynamic Select	Dynamic Select
JSON Parse	JSON
Message	No node	No equivalent. A failed run names the node and what it hit.
Python	API Batch Lookup	Host the code yourself, behind an HTTPS endpoint, and API Batch Lookup sends it the rows many at a time. Moving from Python has a table of pandas steps and the nodes that replace them.
Run Command	No node	Not supported: the server runs no shell commands.

Reporting

Theirs	Trinium	Notes
Email	Send Email	One message per row, per group or per run, with rows attached as CSV or Excel.

Documentation

Theirs	Trinium	Notes
Comment	Note
Tool Container	Container	Can be turned off to bypass the nodes inside it.

What does not carry over

Spatial, predictive, machine learning, text mining and reporting tools. Trinium does tabular data movement and transformation only.
Ordering inside a workflow. Every node in a pipeline runs at once. Work that must finish before other work starts goes in separate pipelines, run in order by a Flow.
File formats: Avro, fixed-width text, SAS, SPSS, Access, .hyper and .yxdb are not read.
Some databases: Oracle, DB2, Teradata and SAP HANA have no connector.

Moving a workflow

List the workflow's inputs and outputs, and create a connection for each system.
Rebuild the tools in order, using the table above. The builder shows each node's columns as you go, so a mismatch shows up before you run.
Rewrite Formula expressions in SQL: IF … THEN … ELSE … ENDIF becomes CASE WHEN … THEN … ELSE … END, and [Field] references keep working. Column names are matched exactly, case included.
Press Test to run a 50-row sample, then deploy to Staging and compare a full run with the Alteryx output. Data Compare reports every row and value that differs.

Alteryx tool names are as of Alteryx Designer 2026.2, from Alteryx's public Designer tools list. Alteryx and Alteryx Designer are trademarks of Alteryx, Inc. Trinium is not affiliated with Alteryx.