Col2Array Operator

Overview

The Col2Array operator converts a column in a table to an array. Tables are an indexed array of objects. The Col2Array operator converts an array of objects into an array of values.

You'll find the Col2Array operator under the Table group to the left of the Data Workflow canvas.

About the Info Window

Here's a breakdown of each setting in the Info window:

Adding a Col2Array Operator

In this example, you'll configure a Data Table component to store random names, followed by a Data Workflow component to convert the data table column into an array.

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

Configure the Data Table Component

First, you'll configure a Data Table component to store your data and input it into a Data Workflow component.

1. In the Module Builder, drag and drop a Data Table component onto your canvas.

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

3. To the left of the component's configuration window, click Data.

4. In the data table, enter the following:

   A
   name
   Minna
   Veronika
   Theola
   Albina
   Ezekiel

5. Click Save & Close.

Configure the Data Workflow Component

Next, you'll configure a Data Workflow component to retrieve the stored data and use a Col2Array operator to convert the data column into an array.

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

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

Configure the Input Operator

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

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

   Setting	Value
   Category	Input
   Component	dtTable
   Required	Yes
   Source	Default

Configure the First Console Operator

Now, add a Console operator before the Col2Array operator to view the current data in the DevTools Console.

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 Col2Array

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

Configure the Col2Array Operator

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

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

   Setting	Value
   Category	Col2Array
   Label
   Drop Empty	Yes
   Path	name
   Default Value

3. Connect the output port (right) of the Input operator to the input port (left) of the Col2Array operator.

Configure the Second Console Operator

Then, add a second Console operator to view the converted array after the data passes through the Col2Array operator.

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

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

   Setting	Value
   Category	Console
   Label	After Col2Array

3. Connect the output port (right) of the Col2Array operator to the input port (left) of the After Col2Array 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 the column in the data table to an array.

1. Drag and drop a Button component onto your canvas, placing it between your Data Table and Data Workflow components.

2. In the Property ID field, enter btnRunDWF.

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

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

   

7. Click Save & Close.

8. Save your module

Below is the completed configuration in the Module Builder:

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