Lookup tables are used to define parameter values in an external comma-separated values (CSV) file. This lets you specify multiple part sizes that are based on a table without creating a separate family type for each size. Vasari provides a size_lookup function that can be used to read the necessary values from a CSV file.
Data from lookup tables for is stored within the family and use the size_lookup function. See Managing Lookup Tables. For upgraded projects, you can define the location of lookup table files with the LookupTableLocation parameter in the Revit.ini file. Folders are created for each type of content installed.
Lookup tables are used in conjunction with type catalogs. For information about creating type catalogs, see Creating a Type Catalog.
The syntax for the size_lookup function uses the following format:
result=size_lookup(LookupTableName, LookupColumn, DefaultIfNotFound, LookupValue1, LookupValue2, ..., LookupValueN)
| Where: | Is: |
| result | the returned value. |
| LookupTableName | the name of the CSV file to lookup. |
| LookupColumn | the name of the column from which the result value is to be returned. |
| DefaultIfNotFound | the value that will be returned if LookupValue is not found. |
| LookupValue(1-N) | the value to find in the first, second, and subsequent columns of the table. (When looking up values, the first column is skipped.) |