DriveWorks Pro 16: Update Column Data in a Simple Table [send feedback...]

Update Column Data in a Simple Table

This Specification Flow Task will update a column value in a Simple Data Table with a Constant value.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Column NumberThe column number whose data will be updated.
New Column ValueThis value will be calculated for the current row, which is written to the Row Number Constant.
Simple Table NameThe name of the DriveWorks Project Simple Table in which the column data will be updated.
Row number ConstantThe Constant that the row number 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
Column Number33This will select column three to insert the new values for.
New Column Value"Aluminum"AluminumThis is the new value that will be inserted for all the rows in the specified column
Simple Table Name"ManufacturingDetails"ManufacturingDetailsThis is the name of the Simple Table that you want to update the values for.
Row Number Constant"DWConstantAffectedRows"DWConstantAffectedRowsThis is the name of the Constant that will report back with how many rows were affected by the task.

Example Data

PartMaterialQuantity
Beam 200x400Stainless Steel2
Corner Bracket LargeStainless Steel4
Beam 200x200Stainless Steel6

Example Result

PartMaterialQuantity
Beam 200x400Aluminum2
Corner Bracket LargeAluminum4
Beam 200x200Aluminum6

Table of Contents