Syntax

   @Lookup(<lut name>, <value> [, <flags>])
   
Arguments

   <lut name>  
   
      Identifies the lookup table. It must have been defined by a Lookup 
      configuration line.
   
      Range: String  
      
   <value>  
   
      The value to be looked up in the named lookup table. The function will 
      then return the found value, or will be blank if none was found. 
   
      Range: String  
      
   <flags>  
   
      Configure how lookups are to be performed. The following values are 
      supported:
      
         REVERSE
         ENCODED_ATTR
         REVERSE|ENCODED_ATTR

Configuration

   The @Lookup function accepts the following configuration line:

   Lookup <lut name> [<source> <rep value>]+ 

   <lut name>  
   
      The name of the lookup table used as the first argument to the @Lookup 
      function.

      Range: String  
      
   <source> 
   
      The value mapped to its replacement value when @Lookup is invoked in the 
      forward direction. 

      Range: String  
      
   <rep value> 
   
      The replacement value returned when the source value is passed to the 
      @Lookup function invoked in the forward direction. 

      Range: String  
      
Description

   The @Lookup function applies alternate values to source values through Lookup 
   Tables (LUTs) during transformation. The LUTs are first defined in the 
   mapping file on their own configuration lines. Many-to-one lookups are 
   supported, but information is lost when the inverse operation is performed 
   using such LUTs.

   If a value to be looked up is not found in the table, then the translation 
   will be aborted and the error will be reported. However, as such situations 
   may occur legitimately, the special source value consisting of a blank string 
   is the default. If a source value cannot be found in the list, then this 
   default will be used if available. In addition, any occurrences of the 
   special word KEY in the default replacement string are substituted with the 
   original source value.

   If the optional REVERSE parameter is specified, the direction of the lookup 
   is reversed. That is, it will perform a lookup from replacement values to 
   source values if operating in the forward direction, or from source value to 
   replacement value if executing in the inverse direction.

   If the optional ENCODED_ATTR is specified, the mapping direction is "FORWARD" 
   and the <value> is expected to be an encoded attribute name. For more 
   information on the encoding method, see Substituting Strings in Mapping Files 
   in the FME Fundamentals help file (available at www.safe.com or via the 
   Workbench and Universal Translator Help menus).

   If the optional REVERSE|ENCODED_ATTR is specified, the mapping direction is 
   "REVERSE" and the <value> is expected to be an encoded attribute name. For 
   more information on the encoding method, see Substituting Strings in Mapping 
   Files in the FME Fundamentals help file (available at www.safe.com or in the 
   <FME install directory>\help folder).

   The @Lookup function is an attribute value function, meaning that it is used 
   to supply a value to an attribute, as opposed to modifying a whole feature.