Skip to main content

LEFT and RIGHT

LEFT

RIGHT

The LEFT and RIGHT keywords indicate the left and right records of a record set. These may be used to substitute as parameters passed to TRANSFORM functions or in expressions in functions where a left and right record are implicit, such as DEDUP and JOIN.

Example:

dup_flags := JOIN(person,person,
               LEFT.current_address_key=RIGHT.current_address_key
               AND fuzzy_equal,req_output(LEFT,RIGHT));

See Also: TRANSFORM Structure, DEDUP