Lookup Paths in logic text

TABLE OF CONTENTS

  1. How to use lookup paths in logic text
  2. Syntax
  3. Rules for the syntax
  4. Examples: lookup paths in Extract Column Logic
  5. Examples: lookup paths in Extract Record Filter

How to use lookup paths in logic text

A lookup path is a method to use one logical file to lookup a record in another logical file. For an introduction, see topic Lookup paths overview.

In logic text, lookup paths are only used in the extract phase, where you can use lookup paths to provide values for columns in view data. You can also use the ISFOUND and ISNOTFOUND functions to check if the lookup path is successful in each particular case.

Lookup paths are used in the format phase only in the Sort Key Title field, which is part of the definition of a sort column in a view. There is no logic text syntax for lookup paths in the format phase.

(Syntax Legend)

Syntax

Lookup path syntax 1

Lookup path syntax 2

Lookup path syntax 3

Lookup path syntax 4

Rules for the syntax

Lookups can only be used in Extract-Phase Record Filter or Extract-Phase Column Logic text.

See also topic: Rules for all Logic Text

Examples: lookup paths in Extract Column Logic

Example logic text           Meaning
COLUMN = {Lookup1.Field2} Set the current column using lookup path Lookup1 to provide Field2 in the target logical record.
COLUMN = {Lookup1.Field2, Field7} Set the current column using lookup path Lookup1 to provide Field2 in the target logical record using effective date of Field7.
COLUMN = {Lookup1.Field2;
    $SYM=”ABC”}		 Set the current column using lookup path Lookup1 to provide Field2 in the target logical record using symbol SYM set to ‘ABC”.
COLUMN = {Lookup3.Field4,
    Field7;$SYM1=3,$SYM2=0}		 Set the current column using lookup path Lookup3 to provide Field4 in the target logical record using effective date of Field7 and symbols SYM1 set to 3 and SYM2 set to zero.
IF ISFOUND({Lookup4;$SYM=”A”})
    THEN COLUMN = {Lookup4;$SYM=”A”}
    ELSE COLUMN = 0
ENDIF		 If lookup path Lookup4 successfully finds a value using symbol SYM set to “A”, then set the current column to that lookup field, otherwise set the current column to zero.

Examples: lookup paths in Extract Record Filter

Example logic text           Meaning
IF ISFOUND({Lookup3})
    THEN SELECT
ENDIF		 Select all input records where the lookup path Lookup3 successfully finds a target record,and skip all other records. This example is the same as:
SELECTIF(ISFOUND({Lookup3}))
SELECTIF(ISFOUND({Lookup2;$SYM=”ABC”})) Select all input records where the lookup path Lookup2 successfully finds a target record using symbol SYM set to “ABC”, and skip all other records.
SELECTIF(ISFOUND({Lookup2, field7 })) Select all input records where the lookup path Lookup2 successfully finds a target record using effective date of field7, and skip all other records.
SELECTIF(ISFOUND({Lookup5, field7; $SYM1=3,$SYM2=0})) Select all input records where the lookup path Lookup5 successfully finds a target record using effective date of field7 and symbol SYM1 set to 3 and symbol SYM2 set to zero. Skip all other records.
IF ISNOTFOUND({Lookup1})
    THEN SKIP
ENDIF		 Skip all input records where the lookup path Lookup1 does not successfully find a target record, and select all other records. This example is the same as:
SKIPIF(ISNOTFOUND({Lookup1}))
SKIPIF(ISNOTFOUND({Lookup2,field7; $SYM1=3,$SYM2=0})) Skip all input records where the lookup path Lookup2 does not successfully find a target record using effective date of field7 and symbol SYM1 set to 3 and symbol SYM2 set to zero. Select all other records.