Transform Reference

Lookup Verbs

Table lookup operations with single-key, multi-key, and reverse lookup support.

VerbSyntaxDescriptionTry It
lookup%lookup TABLE.column @matchTable lookup returning column value (works in any direction) Try
lookupDefault%lookupDefault TABLE.col default @matchLookup with fallback value Try

Examples

Lookup examples 
; Single-column match
body_code = %lookup BODY_TYPES.code @.bodyType       ; "sedan" -> "01"

; Reverse lookup (same syntax)
body_name = %lookup BODY_TYPES.name @.bodyCode       ; "01" -> "sedan"

; Multi-column match
territory = %lookup TERRITORY.territory @.state @.zipPrefix

; With default
code = %lookupDefault BODY_TYPES.code "99" @.bodyType