Summary


This article describes how to use an Excel Lookup to supply document parameter values. This is a legacy feature. Parameter Data Source or Document Source are recommended for supplying parameter values.



 Excel Requirements


Data Lookup


The Excel spreadsheet must contain a key column and a lookup column. The key column value is referenced to return the lookup value for that key. In the example below, state, city and region are key values.


_DfQKqpGBdX6R4XIOEIJf20Fe5h7mEO4sQ.png


Date Lookup


The first column in the Excel spreadsheet must be labeled date, be formatted as DATE and contain a list of dates in format MM/DD/YYYY. The current date (burst execution date) is then used to look up a column containing date information. In the example below, start or end might be used as lookup values.


BBK4Unr0sXqHK8lATJcne8czO-SnIdvGXg.png



 Create a File List


Create a File List that references the Excel file containing the date or data lookup information.



Assign the File List


  • Open the Burst and select the Options tab
  • Select the appropriate lookup button
  • Select the File List



 Reference the Lookup 


  • Select the parameter to receive values from the lookup
  • Source Type: Select Enter Value 
  • Enter the appropriate lookup Macro:
    • Data: [@LOOKUP(KEY)] 
    • Date: [@DATELOOKUP(COLUMN)] 
  • Select the OK button