StateDMI / Command / SetPropertyFromTable

Overview
Command Editor
Command Syntax
Examples
Troubleshooting
See Also

Overview

The SetPropertyFromTable command sets the value of a property used by the time series processor, using a table cell value. The property will be available to subsequent commands that support using ${Property} notation in parameters, for example to specify filenames more dynamically. This command is useful in cases where iteration is processing data from a table, in which case the property can be used in other commands. Filters are used to match one or more rows. The first matched row is used to set the property.

Command Editor

The following dialog is used to edit the command and illustrates the command syntax for general parameters. See also the full-size image.

SetPropertyFromTable Command Editor for General Set Parameters

Command Syntax

The command syntax is as follows:

SetPropertyFromTable(Parameter="Value",...)

Command Parameters

Parameter	Description	Default
`TableID`	The identifier for the table. Can be specified using `${Property}`.	None – must be specified.
`Column`	The name of the column containing the value that will be used to set the processor property. Can be specified using `${Property}`.	None – must be specified.
`ColumnIncludeFilters`	Filters that include rows being matched, by matching column values: `ColumnIncludeFilter1:FilterPattern1,ColumnIncludeFilter2:FilterPattern2` Patterns can use `*` to indicate wildcards for matches. Only string values can be checked (other data types are converted to strings for comparison). All patterns must be matched to exclude the row. Can be specified using `${Property}`.	All rows are matched.
`ColumnExcludeFilters`	Filters that exclude rows being copied, by matching column values: `ColumnExcludeFilter1:FilterPattern1,ColumnExcludeFilter2:FilterPattern2` Patterns can use `*` to indicate wildcards for matches. Only string values can be checked (other data types are converted to strings for comparison). All patterns must be matched to exclude the row. Can be specified using `${Property}`.	All rows are matched.
`PropertyName`	The property name to be set. Can be specified using `${Property}`.	None – must be specified.
`DefaultValue`	The default value to use if no table cell is matched: `Blank` – to use a blank string `Null` – to use a null value Specified value to set to a string value. Can be specified using `${Property}`.	Property is set to null.

Examples

See the automated tests.

The command shown in the editor dialog, used with the following table, will set StringProp=“Abba” See also the full-size image.

SetPropertyFromTable Input Example

Troubleshooting

See the main troubleshooting documentation