Data Workflow: Table Operators

Use Data Workflow's Table operators to append and merge tables, create a nested table, and output data as a string or an object.

TIP  For examples of specific use cases using Data Workflow Table operators, see the How-to Guides: Table Operators section of our How-to Guides.

Introduction to Data Workflow Table Operators

Get an introduction to all of Unqork's Table operators.

Aggregate Operator Learn how to sum, count, calculate means, and determine the maximum and minimum number value of table data using a Data Workflow. Append Operator Learn how to append two values or arrays together using a Data Workflow. Cartesian Operator Learn how to cross join arrays into a single array using a Data Workflow. Clean Keys Operator Learn how to fill empty keys or values using a Data Workflow. Col2Array Operator Learn how to convert a table column into an array using a Data Workflow. Convert Field Operator Learn how to convert values from one data type to another using a Data Workflow. Create Field Operator Learn how to create or update table fields using a Data Workflow. Create Index Operator Learn how to create row indexes using a Data Workflow. Create Table Operator Learn how to create an empty array to add data using a Data Workflow. Filter Operator Learn how to filter table data using a Data Workflow. HTML Table Operator Learn how to convert a data table into an HTML table using Data Workflow. Map Keys Operator Learn how to update multiple table keys simultaneously using a Data Workflow. Map Values Operator Learn how to update multiple table values simultaneously using a Data Workflow. Merge Operator Learn how to combine and inner or outer join two tables into a single table using a Data Workflow.

Multi-row Operator Learn how to duplicate table columns, and move duplicated rows up and down the table using a Data Workflow. Nest By Operator Learn how to create a nested table inside its parent table using a Data Workflow. Nested Array Operator Learn how to create or update fields in a nested array using a Data Workflow. Omit Operator Learn how to remove columns from a table using a Data Workflow. Pick Operator Learn how to retrieve specific columns from a table using a Data Workflow. Rename Field Operator Learn how to rename table fields using a Data Workflow. Size Operator Learn how to determine the size of a string or array using a Data Workflow. Sort Operator Learn how to sort table data in ascending or descending order using a Data Workflow. Split Field Operator Learn how to split values and nest them in a new array using a Data Workflow. Table2HTML Operator Learn how to convert table data into a string with HTML breaks using a Data Workflow. Table2Object Operator Learn how to convert table data into an object using a Data Workflow. Transpose Operator Learn how to transpose (or rotate) columns into rows and rows into columns using a Data Workflow. Unique Operator Learn how to duplicate key/value pairs into an array using Data Workflow. Unwind Operator Learn how to move a nested array up to the next level of a data structure using Data Workflow.