Data Tables Block

• Designer

• 

• Administrator

Data Tables Block

Use this block when you want an application to reference one of your data tables.

Related documentation:

• Getting Started with Designer

You can use the Data Tables block in any phase of your application to read values from a Data Table.

Data Table tab

Select a Data Table in the drop-down list. If you want to enable the option to use the data table as a variable, select Use variable. For example, you might select this option if you are using the same application in multiple locations, and each location needs to refer to a data table that is specific to that location.

Once you have selected a Data Table, you can configure the following:

• Look up by key(s) - For each key in your Data Table, enter a value (or variable, if Variable? is enabled) to use as an input for the Data Table block.
• Strict comparisons - Select this option to use a stricter form of key matching when performing lookups. If enabled, Designer won't trim or ignore leading zeros in numeric columns or spaces in string columns. This option also prevents type-coercion during lookups; for example, strings won't be able to match numeric keys.
• Multiple rows output - Select this option if the lookup key is of a date/time range data type, or if the data table contains multiple keys.
• Store loaded data into these variables - For each column in your Data Table, select a variable to hold the output value of your Data Table block.

Results tab

Select a variable to store the outcome status of the lookup (true or false). You can also select a variable to store the number of returned rows.