Range Lookup Table

You can create a Range lookup table only if some fields of the records create ranges. That means the fields are of the same data type and they can be assigned both start and end. You can see this in the following example:

Appropriate Data for Range Lookup Table

Figure 35.12. Appropriate Data for Range Lookup Table


When you create a Range lookup table, you must check the Range lookup radio button and click Next. (See Figure 35.5, Lookup Table Wizard.)

Range Lookup Table Wizard

Figure 35.13. Range Lookup Table Wizard


Then, in the Range lookup table wizard, you must give a Name to the selected lookup table, and specify Metadata.

You can select Charset and decide whether Internationalization and what Locale should be used.

By clicking the buttons at the right side, you can add either of the items, or move them up or down.

You must also select whether any start or end field should be included in these ranges or not. You can do it by selecting any of them in the corresponding column of the wizard and clicking.

When you switch to the Data source tab, you can specify the file or directly type the data in the grid. You can also write data to lookup table using LookupTableReaderWriter.

By clicking the Edit button, you can edit the data contained in the lookup table. At the end, you only need to click OK and then Finish.

[Important]Important

Remember that Range lookup table includes only the first record with identical key value.