How-to Guides: Table Operators

This section of our How-to documentation lets you explore various use cases using the Data Workflow component's Table operators.

Aggregate Operator

Learn how to use the Aggregate Operator to count data values.

Counting entries in a data set using the Aggregate operator.

Determining the highest number in a data set using the Aggregate operator.

Determining the mean value of a data set using the Aggregate operator.

Determining the lowest number in a data set using the Aggregate operator.

Append Operator

Combine two data sets into one.

Combining two tables into one using the Append operator.

Clean Keys Operator

Use the Clean Keys operator to add missing keys or values.

Adding missing keys and values to a data set using the Clean Keys operator.

Convert Field Operator

Click the individual links leading to different topics.

Converting data to an integer data type using the Convert Field operator.

Converting data to a string data type using the Convert Field operator.

Create Index Operator

Click the individual links leading to different topics.

Creating row indexes in a data table using the Create Index operator.

Identifying duplicate table data using the Create Index operator.

Filtering for a specific row of a table using the Create Index operator.

Create Field Operator

Click the individual links leading to different topics

Using conditional expressions to add different values to the same key using the Create Field operator.

Dynamically add and reference table values using the Create Field operator.

Updating key/value pairs using the Create Field operator.

Merge Operator

Combining table data using a traditional INNER SQL language using the Merge operator.

Combining table data using a traditional OUTER SQL language using the Merge operator.

Adding the same tag to each row of a table using the Merge operator.

Adding different tags to each row of a table using the Merge operator.

Multi-row Operator

Analyzing table data using multiple Multi-row operators.

Nest By Operator

Nesting child data inside its parent array using the Nest By operator.

Nesting data inside an array and converting the array of objects into an array using the Nest By and Table2Object operators.

Omit Operator

Removing duplicate entries created from merged data using the Omit operator.

Rename Field Operator

Renaming complex API fields using the Rename Field operator.

Table2Object

Nesting data inside an array and converting the array of objects into an array using the Nest By and Table2Object operators.

Unique Operator

Using an argument to dynamically locate unique table values using the Unique operator