DriveWorks Pro 15: SppSetColumnInTable [send feedback...]

SppSetColumnInTable

Returns a table with all values set in a given column.

Syntax

SppSetColumnInTable([Table Array],[Column],[New Value],[Exclude Header])

Where:

Table Array is a table array such as the data in a standard table or the result of the QueryDataValues function.

Column is the column on which to set the value. A number starting at 1 for the first column.

New Value is the new value for all rows of the given column.

Exclude Header is TRUE to not set the value in the first row (header), FALSE to set the value for all rows.

Examples

RuleMeaning
SppSetColumnInTable(DWLookupProductData,3,"Bought Out",TRUE)Will apply the value "Bought Out" for all values except the header in the given table.

Table of Contents