Transformations

Transformation nodes receive data as input, process or reshape it, and pass the result to the next node. They always require an incoming connection and always produce an output.

Transformations include nodes that prepare and edit columns in a table (Data Prep), join multiple data sources (Data Joiner), sort rows (Order By), filter rows with a WHERE clause (Query Where), run an in-memory SQL query (Query In Memory), build an Excel file from a DataFrame (Excel Builder), merge multiple Excel files (Excel Merger), export a table to CSV or text (Export Table CSV, Export Table Text), rename a file (Rename File), rename columns (Rename Column), execute a custom script against the data (Custom Script), fill workflow properties from node data (Fill Properties), sign a PDF (Sign PDF), and enhance a PDF (Enhance PDF).