DriveWorks Pro 16: Update Group Table Using Array [send feedback...]

Update Group Table Using Array

This Specification Task will update a Group Table with the values from the given 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 (leave blank to append the data).
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 a new row will be inserted.)
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 properties 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 for the second entry changed from Coates to Jones.

FirstNameSecondNameAge
JohnSmith34
SallyJones31
OllieJarvis25

Table of Contents