- Deep Dive
-
Introduction to Data Types and Data Structures (12 min)
-
Introduction to Data Workflow (30 min)
-
Understanding the Relationship Between Data and the Data Workflow Component
-
Evaluating Data and Developing an Approach (11 min)
-
Splitting and Renaming Keys (16 min)
-
Replacing Blank or Missing Values (8 min)
-
Creating Fields, Appending Data Sets, and Omitting Data (14 min)
-
Creating a KPI and Grouping Operators (9 min)
- Creating and Updating Data Structures
-
Introduction to Creating and Updating Data Structures
-
Using the Unwind Operator
-
Using the Set Operator
-
Set Operator Use Case: Creating Rows in a Table
-
Set Operator Use Case: Adding Key/Value Pairs to Specific Rows in a Table
-
Using the Create Field Operator
-
Create Field Operator Use Case: Dynamically Adding & Referencing Values
-
Create Field Operator Use Case: Adding Key/Value Pairs with a Conditional Value
-
Create Field Operator Use Case: Updating and Conditionally Updating Key/Value Pairs
- Selecting Data
-
Introduction to Selecting Data
-
Using the Get Operator
-
Using the Pick Operator
-
Using the Filter Operator
-
Using the Unique Operator
-
Unique Operator Use Case: Using an Argument to Dynamically Find Unique Values
- Aggregating Data
-
Aggregating Data
-
Using the Aggregate Operator
-
Using the Append Operator
-
Append Operator Use Case: Appending Tables
-
Using the Size Operator
-
Size Operator Use Case: Finding the Size of an Array
-
Using the Join Operator
-
Using the Formula Operator
- Verifying and Manipulating Data Structures
-
Using the Split String Operator
-
Verifying and Manipulating Data Structures
-
Using the Col2Array Operator
-
Using the Array2Col Operator
-
Using the Object2Table Operator
-
Using the Table2Object Operator
-
Using the Sort Operator
-
Using the Excel to JSON Operator
-
Excel to JSON Operator Use Case: Uploading a Multi-Tab Excel Sheet
-
Using the Multi-Row Operator
-
Multi-Row Operator Use Case: Using Multiple Operators
-
Using the Transpose Operator
-
Using the Cartesian Operator
-
Using the Diff Operator
- Test Your Knowledge
-
Quiz
Data Workflow Overview
This course covers Data Workflow component and all the operators within it.
The Data Workflow component provides you with specialized operators for receiving large and complex data structures from multiple sources in real-time, and re-conceptualizing these structures for further use within your application. Data Workflow is quickly becoming one of the most popular aspects of Unqork since its powerful functionality cannot be replicated by solely non-Data Workflow components.
Frequently used operations include:
- Inputting data
- Unwinding complex data structures
- Filtering data to obtain specific items
- Viewing data at different points within the workflow
- Appending data items to create new structures
- Outputting data