Multi-Row Operator

The Multi-Row operator duplicates a table column and shifts it to another row in the same table. Depending on your needs, you can shift data up or down in your table. First, you’ll set the number of rows you want your data shifted and a new key name for the data.

This operator is useful if you want to compare changes in your data over time. Let's say you're tracking your company's stock prices and want to compare the changes over a number of days. You can use the Multi-Row operator to generate that data.

You’ll find the Multi-Row 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 Multi-Row Operator

Let’s say you want to compare your company's stock prices over multiple days. To begin, you’ll create a set of sample data that includes:

• Company Name

• Stock Price

• Date

Then, you use a Data Workflow with a Multi-Row operator to duplicate that data and shift it down one row. Doing so places your current stock prices next to the stock price for the previous day. You can then take the average of those two prices and display this data in a chart.

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

Configure the Data Table Component

First, set up your sample data in a Data Table 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, enter dtStocks.

3. In the data table, enter the following:

   #	stock	price	date
   1	ABC	54	2025-07-01
   2	ABC	65	2025-07-02
   3	ABC	67	2025-07-03
   4	ABC	78	2025-07-04
   5	ABC	99	2025-07-05
   6	ABC	87	2025-07-06
   7	ABC	45	2025-07-07
   8	ABC	32	2025-07-08
   9	ABC	12	2025-07-09
   10	ABC	12	2025-07-10
   11	ABC	12	2025-07-11
   12	ABC	87	2025-07-12
   13	ABC	65	2025-07-13
   14	ABC	54	20251-07-14
   15	ABC	43	20251-07-15
   16	ABC	55	2025-07-16
   17	ABC	66	2025-07-17
   18	ABC	77	2025-07-18
   19	ABC	88	2025-07-19

   

4. Click Save & Close.

Configure the Hidden Component

Before you can duplicate your stock prices using a Data Workflow, you need a Hidden component to store your final data.

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

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

3. Click Save & Close.

Configure the Data Workflow Component

Now it's time to add your Data Workflow. You’ll use an Input operator to bring your data into the Data Workflow. Then, use a Multi-Row operator to duplicate your price data and shift your data up one row. Next, you use a Create Field operator to take the average between your two stock prices. You’ll also configure a Pick operator to select three pieces of data:

• Date

• Stock price

• 2-day average price

Lastly, an Output operator outputs the data in the multiOutput Hidden component.

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

2. In the Canvas Label Text and Property Name fields, enter dwfMultiRow.

   

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	dtStocks
   required	Yes
   Source	Default

Configure the Multi-Row Operator

This operator duplicates your price data and moves it up one row.

1. Drag and drop a Multi-Row operator onto your Data Workflow canvas.

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

   Setting	Value
   category	Multi-Row
   label	Price
   Default	0
   Key Name	price
   Steps	1
   New Key Name	nextDayPrice

3. Connect the output port (right) of the dtStocks Input operator to the input port (left) of the Price Multi-Row operator.

Configure the Console Operator

This operator lets you view your data after it passes through the Multi-Row 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	Multi-Row Result

3. Connect the output port (right) of the Price Multi-Row operator to the input port (left) of the Multi-Row Result Console operator.

Configure the Create Field Operator

This operator finds the average of your two stock prices. It then places that average in a new key of your table called priceAvg.

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

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

   Setting	Value
   category	Formula
   label	priceAvg
   Do Not Sanitize Formula	(checked)
   Field 1	priceAvg=SUM(price,nextDayPrice)/2
   Field 2
   Field 3
   Field 4
   Field 5

3. Connect the output port (right) of the Price Multi-Row operator to the input port (left) of the priceAvg Create Field operator.

Configure the Pick Operator

The Pick operator selects the date, price, and priceAvg values from your data.

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

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

   Setting	Value
   category	Pick
   label	date,price,priceAvg
   Pick Keys	date,price,priceAvg

3. Connect the output port (right) of the priceAvg Create Field operator to the input port (left) of the date,price,priceAvg Pick operator.

Configure the Output Operator

This operator outputs the data from your Pick operator into your Hidden component.

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	multiOutput
   action	value

3. Connect the output port (right) of the date,price,priceAvg Pick operator to the input port (left) of the multiOutput Output operator.

4. Click Save.

Configure the Chart Component

With your new data created, you'll display it in a Chart component. Remember, your Hidden component stores the date, the stock price for that date, and the 2-day average stock price for that date. So, you’ll set the date as the X-axis for the other data points.

1. Drag and drop a Chart component onto your canvas, placing it below the multiOutput Hidden component.

2. In the Label field, enter 2 Day Moving Avg.

3. In the Property Name field, enter chartAverage.

4. In the Inputs table, enter the following:

   ID	Label	Chart Type	Categories	Values
   multiOutput	Price	line	date	price
   multiOutput	2 Day Avg	line	date	priceAvg

   

5. Click the Formatting tab at the top of the configuration window.

   1. In the X Axis Label field, enter Date.

   2. In the Y Axis Label (Primary) field, enter Price.

   3. Set Show Legend to Yes (checked).

      

6. Click Save.

Configure the Button Component

Lastly, add a Button component to trigger your Data Workflow.

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

2. In the Property ID, enter btnMultiRow.

3. In the Label Text field, enter Start Multi-Row.

4. Set the Action Type to Event.

5. In the Trigger on Click field, enter dwfMultiRow.

   

6. Click Save & Close.

7. Save your module.

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

Preview your module in Express View and click the Start Multi-Row button. Your chart populates with the data from your Hidden component and displays the average stock prices that have changed over two days.

Open the DevTools Console to review the results from the Multi-Row operator. Here, you can see that each row of your data now contains nextDayPrice. This result is generated by your Multi-Row operator, taking your original price data and moving it up a row.