Returns a Table Array with all values set to a given value for the specified column.
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.
| Rule | Result | Meaning |
|---|---|---|
| SppSetColumnInTable(DWLookupProductData,4,"FALSE",TRUE) | {"ID","Name","Value","Instock"; "1","Product A","24.99","FALSE"; "2","Product B","13.00","FALSE"; "3","Product C","8200.00","FALSE"; "4","Product D","123.00","FALSE"; "5","Product E","3141.59","FALSE"} | Will apply the value "FALSE" for all values except the header in the given table. |
| ID | Name | Value | Instock |
|---|---|---|---|
| 1 | Product A | 24.99 | TRUE |
| 2 | Product B | 13.00 | TRUE |
| 3 | Product C | 8200.00 | TRUE |
| 4 | Product D | 123.00 | TRUE |
| 5 | Product E | 3141.59 | TRUE |