Configure the @lookupCsv function

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

Use this procedure to configure the @LookupCsv function. This function looks up the value for a property in a comma separated values file. The value will be inserted in the document property you are configuring.

  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:
    OptionDescription
    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.
    ToDo 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)