Create Table Operator

Overview

A static image displaying the Data Workflow component's Create Table Operator icon and configuration window.

The Create Table operator creates an array An array is a type of object that stores one or more data types. Data types supported in arrays include numbers, strings, and objects. with one or more empty rows in a Data Workflow. These empty rows can be filled using other operators in the Data Workflow, or at a later time.

To set the number of rows in the array:

  • Hard-code them using the operator's Info window.

  • Use another component as an argument for the operator.

The Create Table operator serves as the start of your Data Workflow, and does not have an input port. It also includes an argument port for determining the value it creates. Connect another operator to the Create Table operator's argument port. Then, in the Expression/Value field, use the _arg value to reference that value.

You can find the Create Value operator under the I/O group to the left of your Data Workflow canvas.

About the Info Window

Learn more about each setting in the Create Table operator's Info window:

Setting

Description

Category

Grayed out and non-adjustable setting indicating the operation type.

Label

Sets the label for your operator, displaying below the operator on your Data Workflow canvas.

This field is optional, but set a label if you use more than one of the same operator type. A label helps you identify your operators without opening any Info windows.

Preserve Argument Type

When selected, this setting ensures the argument data type is respected when the operator executes.

Create Index

When set to YES, the operator creates an index key for each row or object. This field contains an integer value of the index for that row. This index makes it easier to parse or position your data based on the order of the rows.

When set to NO, your operator does not create an index.

You might want an index if you plan to use the Merge or Append operators in your Data Workflow.

Number of Rows

The number you enter here determines how many rows the operator creates. If you need two rows, enter 2.

To use another operator as an argument, connect its output port to the Create Table operator's argument port. Then, enter _arg as your Number of Rows. Your argument operator must output an integer.

Adding a Create Table Operator

For this example, create an empty table with two rows using a Data Workflow component. Then, outptu this data to a Hidden component.

Configure the Hidden Component

Add a Hidden component to store the array An array is a type of object that stores one or more data types. Data types supported in arrays include numbers, strings, and objects. you'll create using a Data Workflow.

1. In the Module Builder, drag and drop a Hidden component onto your canvas.
2. In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. and Label Text Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. fields, enter tableOutput.
3. Click Save Component.

Configure the Data Workflow Component

Next, you'll configure a Data Workflow component and use the Create Table operator.

1. Drag and drop a Data Workflow component onto your canvas, placing it above the tableOutput Hidden component.
2. In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. and Canvas Label Text Canvas Label Text indicates the purpose of the corresponding field or component. For non-input components, the Canvas Label Text isn't end-user facing, and only appears in the . fields, enter dwfTable.

Configure the Create Table Operator

1. Drag and drop a Create Table operator onto your Data Workflow canvas.
2. Configure the operator's Info window as follows:
Info

Category

Create Table

Label

createTable

Preserve Argument Type

☐ (unchecked)

Create Index

Yes

Number of Rows

2

Configure the Output Operator

1. Drag and drop an Output operator onto your Data Workflow canvas.
2. Configure the operator's Info window as follows:
Info

Category

Output

Component

tableOutput

Action

Value

3. Connect the output port (right) of the Create Table operator to the input port (left) of the Output operator.
4. Click Save Component.

Here's how the completed Data Workflow looks:

A static image displaying the configured operators on the Data Workflow canvas.

Configure the Button Component

Lastly, configure a Button component to trigger the Data Workflow.

1. Drag and drop a Button component Icon Button component onto your canvas, placing it below the valueOutput Hidden component.
2. In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. field, enter btnTrigger.
3. In the Label Text Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. field, enter Run DWF Create Table.
4. Navigate to the Actions settings.
5. From the Action Type drop-down, select Event.
6. From the On Click drop-down, enter or select dwfTable.
7. Click Save Component.
8. Save your module.

Your completed module looks like the following:

A static image displaying the complete Data workflow module.

Preview your module in Express View Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View. and click Run DWF Create Table. Then, open the DevTools Console The DevTools Console helps you securely store, build, test, and deploy your software. and run the Angular command The Angular command, or data command, is a tool that displays submission data in a browser's developer console. In Express View, enter the following command in the devtool console: angular.element('.unqorkio-form').scope().submission. Expand the  data: and tableOutput fields to see the empty array An array is a type of object that stores one or more data types. Data types supported in arrays include numbers, strings, and objects. containing two rows.

Overview

A static image displaying the Data Workflow component's Create Table Operator icon and configuration window.

The Create Table operator creates an array An array is a type of object that stores one or more data types. Data types supported in arrays include numbers, strings, and objects. with one or more empty rows in a Data Workflow. These empty rows can be filled using other operators in the Data Workflow, or at a later time.

To set the number of rows in the array:

  • Hard-code them using the operator's Info window.

  • Use another component as an argument for the operator.

The Create Table operator serves as the start of your Data Workflow, and does not have an input port. It also includes an argument port for determining the value it creates. Connect another operator to the Create Table operator's argument port. Then, in the Expression/Value field, use the _arg value to reference that value.

You can find the Create Value operator under the I/O group to the left of your Data Workflow canvas.

About the Info Window

Learn more about each setting in the Create Table operator's Info window:

Setting

Description

Category

Grayed out and non-adjustable setting indicating the operation type.

Label

Sets the label for your operator, displaying below the operator on your Data Workflow canvas.

This field is optional, but set a label if you use more than one of the same operator type. A label helps you identify your operators without opening any Info windows.

Preserve Argument Type

When selected, this setting ensures the argument data type is respected when the operator executes.

Number of Rows

The number you enter here determines how many rows the operator creates. If you need two rows, enter 2.

To use another operator as an argument, connect its output port to the Create Table operator's argument port. Then, enter _arg as your Number of Rows. Your argument operator must output an integer.

Adding a Create Table Operator

For this example, create an empty table with two rows using a Data Workflow component. Then, outptu this data to a Hidden component.

Configure the Hidden Component

Add a Hidden component to store the array An array is a type of object that stores one or more data types. Data types supported in arrays include numbers, strings, and objects. you'll create using a Data Workflow.

1. Drag and drop a Hidden component onto your canvas.
2. In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. and Label Text Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. fields, enter tableOutput.
3. Click Save Component.

Configure the Data Workflow Component

Next, you'll configure a Data Workflow component and use the Create Table operator.

1. Drag and drop a Data Workflow component onto your canvas, placing it above the tableOutput Hidden component.
2. In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. field, enter dwfTable.
3. In theCanvas Label Text Canvas Label Text indicates the purpose of the corresponding field or component. For non-input components, the Canvas Label Text isn't end-user facing, and only appears in the . field, enter dwfTable.

Configure the Create Table Operator

1. Drag and drop a Create Table operator onto your Data Workflow canvas.
2. Configure the operator's Info window as follows:
Setting Value

Category

Create Table

Label

createTable

Preserve Argument Type

☐ (unchecked)

Create Index

Yes

Number of Rows

2

Configure the Output Operator

1. Drag and drop an Output operator onto your Data Workflow canvas.
2. Configure the operator's Info window as follows:
Setting Value

Category

Output

Component

tableOutput

Action

Value

3. Connect the output port (right) of the Create Table operator to the input port (left) of the Output operator.
4. Click Save.

Here's how the completed Data Workflow looks:

A static image displaying the configured operators on the Data Workflow canvas.

Configure the Button Component

Lastly, configure a Button component to trigger the Data Workflow.

1. Drag and drop a Button component Icon Button component onto your canvas, placing it below the valueOutput Hidden component.
2. In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. field, enter btnTrigger.
3. In the Label Text Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. field, enter Run DWF Create Table.
4. Set the Action Type to Event.
5. From the On Click drop-down, enter or select dwfTable.
6. Click Save & Close.
7. Save your module.

Your completed module looks like the following:

Preview your module in Express View Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View. and click Run DWF Create Table. Then, open the DevTools Console The DevTools Console helps you securely store, build, test, and deploy your software. and run the Angular command The Angular command, or data command, is a tool that displays submission data in a browser's developer console. In Express View, enter the following command in the devtool console: angular.element('.unqorkio-form').scope().submission. Expand the  data: and tableOutput fields to see the empty array An array is a type of object that stores one or more data types. Data types supported in arrays include numbers, strings, and objects. containing two rows.