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.

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

Get Started

Introduction to Data Workflow Table Operators

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

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 sort table data in ascending or descending order 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.

Feedback

Did you find this helpful? Yes No

Sorry about that

Want to tell us more? If you're an Unqork employee, please visit our #documentation-feedback Slack channel. Or you can email your feedback to our documentation team.

Great!

Want to tell us more? If you're an Unqork employee, please visit our #documentation-feedback Slack channel. Or you can email your feedback to our documentation team.