DriveWorks Pro 17: Update A Single Value In A Simple Table [send feedback...]

Update A Single Value In A Simple Table

This Specification Task will update a single value in a Simple Table.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Simple Table NameThe name of the Simple Table in which the cell will be updated.
Column NumberThe column number of the cell to be driven.
Row NumberThe row number of the cell to be driven (row 1 is the table header row).
New ValueThe value to be driven into the specified cell.

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
Simple Table NameEmployeesEmployeesWill update the cell in the table Employees.
Column Number33Will update the cell in the third column (Age).
Row Number44Will update the cell in the fourth row (the header row is always the first row).
New Value2626Will replace the current value with 26.

Example Data

This is an example list of employees details stored in a Simple Table named Employees.

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
OllieJarvis26

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

  • Value was successfully set.

Success with Warnings

  • N/A - should never be fulfilled.

Failed (one of the following occurred)

  • Invalid row number.
  • Invalid column number.
  • Invalid simple table or does not exist.
  • General failure - Check the Specification report for more details.

Table of Contents