Leveraging Lookups and Subsearches

Course structure

Using Lookup Commands

• Understand lookups
• Use the inputlookup command to search lookup files
• Use the lookup command to invoke field value lookups
• Use the outputlookup command to create lookups
• Invoke geospatial lookups in search

Adding a Subsearch

• Define subsearch
• Use subsearch to filter results
• Identify when to use subsearch
• Understand subsearch limitations and alternatives

Using the return Command

•  Use the return command to pass values from a subsearch
• Compare the return and fields commands