Home Search

DriveWorks Pro 21
Update Group Table Using Array

Send Feedback

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.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Array ValueA Table Array value, such as the result of a QueryDataValues function.
Control Column NameThe name of the control column.
Control Column ValueThe 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 NameThe name of the DriveWorks Group Table that the Array will be written to.

Example

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 NameExample RuleExample ResultMeaning
Array ValueDWVariableArrayData{"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"EmployeeDataThis is the name of the Group Table to update.
Control Column Name"FirstName"FirstNameThis is the of the Column that you want to use as the Control Value.
Control Column Value"Sally"SallyThis is the Control value that will be used to Identify where to add the new data.

Example Data

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

FirstNameSecondNameAge
JohnSmith34
SallyCoates31
OllieJarvis25

Example Result

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

FirstNameSecondNameAge
JohnSmith34
SallyJones31
OllieJarvis25