A reusable Variable named TaxConfiguration uses VLOOKUP_RECORD to retrieve a single TaxConfiguration__c record based on the source record’s BillingAddress. Field mappings then reference #TaxConfiguration fields (TaxRate, TaxCode, ReportingRegion) without repeating VLOOKUPs, keeping mappings concise and maintainable.
Overview
General Use Case
- Use Variables to define reusable, named expressions that can be referenced across Executables.
- Use VLOOKUP_RECORD in a Variable to fetch a single record once and reference multiple target fields from it, avoiding repeated VLOOKUPs and keeping mappings concise and consistent.
Video Demo
Walkthrough
1
Define Reusable Variable

2
Reference Variable Fields in Mappings
