Page Comparison

...

• Hover over RegionsByCounty and press press Image Modified- Add a new Connector
• Move the pointer over the top of Customer Details with Region and select – this will attach the end of the pipe to the selected stream
• In the pipe details form that pops up:
  • Enter the Name: region
  • Type: Look-up
  • Data To Read: leave as the default – Latest
  • Press Image Added - Apply
  • In the Order/Index section we will set up the fields to match across the two data sets:
    • Press  - Show Source and Target Attributes
    • Drag the attribute County from the left hand list (the input attributes from the stream RegionsByCounty) into the list of Order/Index attributes
    • Drag the attribute County from the right hand list (the output attributes from the stream Customer Details with Region) on top of the Order/Index attribute County
      • You should see the Index Expression of the Order/Index attribute update to _out.County
      • This means that the lookup will match records in the reference data (RegionsByCounty) where County = County in the output data (Customer Details with Region)
    • Press 
  • Note that the pipe linking RegionsByCounty to Customer Details with Region is dashed; this indicates that this is a lookup pipe
  • When adding lookup pipes remember that the arrow points in the direction that the data flows; here you are getting data from RegionsByCounty to add to Customer Details with Region

...