View source for DES/Current/Designer/DataTable

{{Article
|Standalone=No
|DisplayName=Data Tables Block
|TocName=Data Tables Block
|Context=Use this block when you want an application to reference one of your data tables.
|ComingSoon=No
|Platform=GenesysEngage-cloud
|Role=Administrator
|Application=Designer
|Section={{Section
|alignment=Vertical
|structuredtext=You can use the '''Data Tables''' block in any phase of your application to read values from a {{Link-SomewhereInThisManual|topic=DataTables|anchor=top|display text=Data Table}}.
|Status=No
}}{{Section
|sectionHeading=Data Table tab
|anchor=DataTabletab
|alignment=Vertical
|structuredtext=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 must configure the following:
<ul>
<li>'''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.</li>
<li>'''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. 
<li>'''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.</li>
</ul>

[[File:des_data_table_properties.png]]
|Status=No
}}{{Section
|sectionHeading=Results tab
|anchor=Resultstab
|alignment=Vertical
|structuredtext=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.

[[File:des_data_table_block_results.png]]
|Status=No
}}
}}