Update Group Table Using Array (DriveWorks Documentation)

Update Group Table Using Array

This Specification Flow Task will update a group table with the values from the given array.

Properties

Property Name	Description
Array Value	A table array value, such as the result of a QueryDataValues function.
Control Column Names	The control column names (leave blank to append the data). This is the name of the column or columns in the Group Table that control the update. Multiple column names are separated with the pipebar "\|". Control Columns determine if a row is inserted, updated, or ignored. When no Control Columns are specified, all data in the array will be appended to the Group Table. If the values in the Control Columns of a row do not match an existing row in the table then DriveWorks will insert a new row. If the values in the Control Columns of a row match an existing row in the table then DriveWorks will update the existing row. If any of the values in the Control Columns of a row are blank, then DriveWorks will ignore the row.
Group Table Name	The name of the DriveWorks Group Table that the array value will be written to.
Title	Changes the Title (not the name) of the task.

Example

When this task is added the properties are static by default.
See How To: Change A Static Property To A Dynamic Property to enable rules to be built on these properties.

Property Name	Example Rule	Meaning
Array Value	DWVariableCustomerData Or {"UserID","CustomerName";"10001","DriveWorks Ltd"}	The Array that will update the Group Table.
Control Column Names	"UserID" Or "UserID\|CustomerName"	The name of the column or columns in the Group Table that control if the update will insert a new row, update an existing row or ignore the row.
Group Table Name	"Customers"	The name of the Group Table that the Array will be Written too.

Property Name

Example Rule

Meaning

Array Value

DWVariableCustomerData

{"UserID","CustomerName";"10001","DriveWorks Ltd"}

The Array that will update the Group Table.

Control Column Names

"UserID"

"UserID|CustomerName"

The name of the column or columns in the Group Table that control if the update will insert a new row, update an existing row or ignore the row.

Group Table Name

"Customers"

The name of the Group Table that the Array will be Written too.

Using the Task in a Specification Macro

This task has different types of Outputs. For more information about Outputs see Specification Macros Task Node.

Outputs are only available within Specification Macros. Currently Outputs are not available for Specification Flow.

Status Outputs

This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.

The status output navigation is as follows:

Success

Successfully updated Group table from array provided.

Success with Warnings

Failed (one of the following occurred)

Table name was empty.
Table with name provided doesn't exist.
Given data was of an incorrect type.
General error - see Specification report for more information.

DriveWorks Pro 23 Update Group Table Using Array