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. Examples include the following:

Aggregate Operator

• 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

• Combining two tables into one using the Append operator.

Clean Keys Operator

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

Convert Field Operator

• 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

• 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

• 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.