Properties of Associative Search Database window

Use this window to configure an Associative Search Database. This window has the following properties:

Import Source

This group has the following settings:

Import from a semicolon-separated CSV file

Browse to and select a CSV file.

First line contains captions

Select this setting if the first record of the input file contains the column headers. This setting is selected by default.

Automatic update from import file

Select this setting to update the Associative Search Database when the source file is updated. This setting is cleared by default.

If this setting is selected, the database is updated when Transformation Server runs during production.

This automatic update feature is not supported by Azure.

Field Configuration

The table lists the following columns:Field Name, Search, and Filter columns for the selected CSV file. Selecting the Search value for a record includes that field in the search. Selecting the Filter value makes that field available for filtering via script.

• Field Name.

• Search.

  If this value is selected for a field, it is used in the search.

• Filter.

  If this value is selected for a field, it is possible to filter the data before searching to reduce the number of possible records. The application of filtering is possible only using scripting.

This menu has the following setting:

Column used as record identifier

Select a column from the list to be used to help identify the records. This column must contain a unique alpha-numeric identifier for each record. The first column of the database is selected by default.