CAS 6

---

lookupn

- Miscellaneous

Summary

Populate a field by looking up values in another CAS file (the 'Lookup file') based on multiple keys. Note: All field names should be in quotes.

Examples

PENALTY gt (STATE lookup 'c:\subdir\file.cas' 'STATE' 'MAXPENALTY')
lookupn 'C:\data\programs' 'PROGRAM' 'RATETYPE' 'ORIGTERM' 'INDEX'

Syntax

(CurrentKey) lookupn 'LookupSource'  'ReturnField' 'Keyfield1' ('KeyField2') ('KeyField3')

Left Arguments

Name	Data Type	Input Type	Description	Optional	Default
CurrentKey	Text	Constant	Key field in active CAS file.	Yes

Right Arguments

Name	Data Type	Input Type	Description	Optional	Default
LookupSource	Text	Constant	Filepath or table name in current CAS file	No
ReturnField	Text	Constant	Name of field containing values to return	No
KeyField1	Text	Constant	Name of key field in other cas file	No
KeyField2	Text	Constant	Name of key field in other cas file	Yes
KeyField3	Text	Constant	Name of field containing values to return	Yes

Result

Type: Text

Build 6.0.624