Configure the @lookupCsv function

This function looks up the value for a property in a CSV file.

1. Right-click in the appropriate document property and click Insert Function > @lookupCsv.
   This opens the @LookupCsv dialog box.
2. Select how you want to locate the CSV file. You can use one of the following options:

   Option	Description
   Path	Enter the path and file name of the CSV file, or click the browse button (...) to navigate to the file.
   Resource	Select the appropriate resource from the list, or click the browse button to choose the resource in the Manage CsvDocProp Resources dialog box. If you are using a resource, CsvDocProp: will be inserted before the resource name.

3. In the Lookup data box, specify the data you are looking up. This could be data from another document property or the results of a @parse function.

   To	Do this
   Select a document property	Right-click in the box, click Insert Document Property, and then select the appropriate property from the list.
   Use the results of a @parse function	Right-click in the box, click Insert Function, and then @parse() from the list. Configure the @parse function using the @Parse dialog box.

4. In the Key column name box, enter the column name in your CSV file where Output Manager should look for a value that matches the data you entered in the Lookup data box.
5. In the Data column name box, enter the column name in your CSV file that contains the value you want inserted into the document property.
6. Click OK.
   The function is inserted into the document property using the following format:

   @lookupCsv("path/resource",lookup data,key column name,data column name)