Look Up - Sample 2

Reporting Design Cookbook Data Design
1

The recipe illustrates how variables are used within the lookup processor.

Remember that the fieldname itself, can be reference as a parameter, like add the “${” and “}” syntax.

Steps taken:

  1. Create a composite datasource (cmps-Employee.ds). Drag and drop sav-Employee.ds as the beginning of the flow.
  2. Add a “Filter” element following sav-Employee.ds. Make the following settings within the “Filter” element:Column Name=position_title, Type=String, When=Equals, Condition=${position_title}
  3. Add a “Parameters” element following the “Filter” element. Name it “Lookup” and select the “Iterate” checkbox.
  4. Drag and drop sav-Employee-position_title.ds into the blank area above the flow. Draw a flow between sav-Employee-position_title.ds and the “Parameters” (Lookup) element.

To download the necessary files for this recipe, refer to the attached ZIP file.Lookup-2.zip