Object2Table Operator

Overview

The Object2Table operator creates a table from an object, with each key/value pair in the object becoming a row in the final table. Because a table is an indexed array of objects, each key/value pair in the object becomes a separate object in an array.

You'll find the Object2Table operator under the Object group to the left of the Data Workflow canvas.

About the Info Window

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

Adding and Configuring the Object2Table Operator

This example uses the Object2Table operator to create a table out of an object. You'll also define the object using a Hidden component.

These instructions assume you have a new module open and saved with a title.

Configure the Hidden Component

First, you'll configure a Hidden component to create a sample object. Define a JSON object in the Default Value field. This sample object contains three key/value pairs.

1. Drag and drop a Hidden component onto your canvas.

2. In the Property ID and Canvas Label Text fields, enter sampleObject.

3. Navigate to the component's Data section.

4. In the Default Value field, enter {"name":"Theola", "age":35, "city":"Massapequa"}.

   

5. Click Save & Close.

Configure the Data Workflow Component

Next, you'll configure the Data Workflow that converts your object into a table.

1. Drag and drop a Data Workflow component onto your canvas, placing it below the sampleObject Hidden component.

2. In the Canvas Label Text and Property ID fields, enter dwfObject2Table.

Configure the Input Operator

This operator brings your source data into the Data Workflow.

1. Drag and drop an Input operator onto your Data Workflow canvas.

2. Configure the Input operator's Info window as follows:

   Setting	Value
   Category	Input
   Component	sampleObject
   Required	Yes
   Source	Default

Configure the First Console Operator

This operator helps you view the Data Workflow before its modified. Later, you'll add another Console operator to show the results of the Object2Table operator.

1. Drag and drop a Console operator onto your Data Workflow canvas.

2. Configure the  operator's Info window as follows:

   Setting	Value
   Category	Console
   Label	Before Object2Table

3. Connect the output port (right) of the sampleObject  Input operator to the input port (left) of the Before Object2Table  Console operator.

Configure the JSON Parse Operator

This operator takes the JSON object defined in your Hidden component and converts it into an object data structure.

1. Drag and drop a JSON Parse operator onto your Data Workflow canvas.

2. Configure the operator's Info window as follows:

   Setting	Value
   Category	JSON Parse
   Label	JSON Parse

3. Connect the output port (right) of the sampleObjectInput operator to the input port (left) of the JSON ParseJSON Parse operator.

Configure the Object2Table Operator

Now, set up the Object2Table operator. Notice the value you enter in the Info window's Key Column Name and Value Column Name fields. These are the two column headers of your final table.

1. Drag and drop an Object2Table operator onto your Data Workflow canvas.

2. Configure the operator's Info window as follows:

   Setting	Value
   Category	Object2Table
   Label	Create Table
   Key Column Name	testKey
   Key Value Name	testValue

3. Connect the output port (right) of the JSON ParseJSON Parse operator to the input port (left) of the Create TableObject2Table operator.

Configure the Second Console Operator

This operator lets you view the results of the Object2Table operator. When creating applications, you'll typically use a dedicated Output operator to store the data in a Hidden component.

1. Drag and drop a Console operator onto your Data Workflow canvas.

2. Configure the operator's Info window as follows:

   Setting	Value
   Category	Console
   Label	After Object2Table

3. Connect the output port (right) of the Create Table  Object2Table operator to the input port (left) of the After Object2Table  Console operator.

4. Click Save.

Here's how the completed Data Workflow looks:

Configure the Button Component

Lastly, add a Button component to trigger the Data Workflow and convert your object into a table.

1. Drag and drop a Button component onto your canvas, placing it above the Data Workflow component.

2. In the Property ID field, enter btnRunDWF.

3. In the Label Text field, enter Run Object2Table.

4. To the left of the component's configuration window, click Actions.

5. Set the Action Type as Event.

6. From the On Click drop-down, select dwfObject2Table.

   

7. Click Save & Close.

8. Save your module.

Here's how the completed example looks in the Module Builder:

Preview your module in Express View and open the DevTools Console. Click the button and view the data before and after Object2Table operation.