Update Group Table Using Array (DriveWorks Documentation)

Update Group Table Using Array

This Specification Task will update a Group Table with the data from the given array.

Please see the standard task Update Group Table Using Array to append all rows from an array.

Property Name	Description
Title	Changes the Title (not the name) of the task.
Array Value	A Table Array value, such as the result of a QueryDataValues function.
Control Column Name	The name of the control column.
Control Column Value	The value of the control column. If this value exists in the Group Table control column, the data will overwrite that row. If it does not exist (or this field is blank) the first row of the array will be appended to the table.
Group Table Name	The name of the DriveWorks Group Table that the Array will be written to.

When this Task is added the properties are static. To be able to build rules on a static property see How To: Change A Static Property To A Dynamic Property.

Property Name	Example Rule	Example Result	Meaning
Array Value	DWVariableArrayData	{"FirstName","SecondName","Age";"Sally","Jones","31"}	This is the Variable where the Array that will be used to update the Group Table is stored.
Group Table Name	"EmployeeData"	EmployeeData	This is the name of the Group Table to update.
Control Column Name	"FirstName"	FirstName	This is the of the Column that you want to use as the Control Value.
Control Column Value	"Sally"	Sally	This is the Control value that will be used to Identify where to add the new data.

This is an example list of employees details that will be updated using the given Array.

This is the example result showing the SecondName of the second entry changed from Coates to Jones.