#!F-adobe-helvetica-medium-r-normal--18*
#!N 
#!N  #!Rlookup Lookup #!N #!N 
Category #!N #!N  #!Lcattrn,dxall763 h Transformation  #!EL  #!N #!N Function #!N #!N #!N #!N 
Syntax #!CForestGreen #!N #!N  #!F-adobe-courier-bold-r-normal--18*   #!N  #!F-adobe-times-bold-r-normal--18*   output #!EF = Lookup( 
 #!F-adobe-times-bold-r-normal--18*   input, table, data, lookup, value, destination, ignore #!EF ); #!EF 
#!N #!N #!EC #!N #!N Inputs #!T,1,91,276,461,646  #!F-adobe-times-medium-r-normal--14*    #!F-adobe-times-bold-r-normal--18*   #!N TAB 
Name TAB Type TAB Default TAB Description #!EF #!N TAB input 
TAB field, string list, value, value TAB (none) TAB object to 
lookup #!N TAB - TAB list TAB - TAB #!N TAB 
table TAB field, string, value list TAB (dataname lookup) TAB lookup 
table #!N TAB data TAB string TAB "data" TAB component of 
input to lookup #!N TAB lookup TAB string TAB "positions" TAB 
component of table in which to #!N TAB - TAB - 
TAB - TAB look #!N TAB value TAB string TAB "data" 
TAB component in table containing #!N TAB - TAB - TAB 
- TAB lookup results #!N TAB destination TAB string TAB "lookedup" 
TAB component of input in which to put #!N TAB - 
TAB - TAB - TAB result #!N TAB ignore TAB string 
list TAB (no default) TAB Properties to ignore in string #!N 
TAB - TAB - TAB - TAB lookup #!N TAB - 
TAB - TAB - TAB #!EF #!N #!N Outputs #!T,1,161,321,646  #!F-adobe-times-medium-r-normal--14*   
 #!F-adobe-times-bold-r-normal--18*   #!N TAB Name TAB Type TAB Description #!EF #!N TAB 
output TAB field or array TAB field or array with looked-up 
values #!N TAB - TAB - TAB #!EF #!N #!N Functional 
Details #!N #!N #!I0 #!N #!N #!I0 #!N  #!F-adobe-times-bold-r-normal--18*    #!F-adobe-times-bold-r-normal--18*   input 
#!EF #!EF #!I50 #!N field containing the component to use as 
lookup #!N #!I0 #!N  #!F-adobe-times-bold-r-normal--18*    #!F-adobe-times-bold-r-normal--18*   table #!EF #!EF #!I50 #!N 
field containing the lookup table components #!N #!I0 #!N  #!F-adobe-times-bold-r-normal--18*    #!F-adobe-times-bold-r-normal--18*   
data #!EF #!EF #!I50 #!N component in input to use for 
looking up #!N #!I0 #!N  #!F-adobe-times-bold-r-normal--18*    #!F-adobe-times-bold-r-normal--18*   lookup #!EF #!EF #!I50 
#!N component in table that the data component is to match 
#!N #!I0 #!N  #!F-adobe-times-bold-r-normal--18*    #!F-adobe-times-bold-r-normal--18*   value #!EF #!EF #!I50 #!N component 
in table to use as the looked up result #!N #!I0 
#!N  #!F-adobe-times-bold-r-normal--18*    #!F-adobe-times-bold-r-normal--18*   destination #!EF #!EF #!I50 #!N component of input 
in which to put the looked up results #!N #!I0 #!N 
 #!F-adobe-times-bold-r-normal--18*    #!F-adobe-times-bold-r-normal--18*   ignore #!EF #!EF #!I50 #!N properties to ignore in 
string lookup. Can be one of "case," "space," "lspace," "rspace," "lrspace," 
"punctuation." "case" means to ignore the case of the characters, "space" 
means to ignore all white space (spaces, tabs, ...), "lspace" means 
to ignore white space on the left side of the string, 
"rspace" means to ignore white space on the right side of 
the string, "lrspace" means to ignore white space on both the 
left and right sides (but not internal white space), and "punctuation" 
means to ignore all punctuation characters (anything other than alphabetic and 
numeric characters and white space).  #!F-adobe-times-bold-r-normal--18*   ignore #!EF can be a 
list of strings; for example, a commonly used combination is ¤"space," 
"case," "punctuation"‡. #!I0 #!N #!N #!N #!N Lookup uses one component 
to find another by "looking up" the corresponding value in a 
lookup table. Lookup serves to convert a categorized component back to 
its original form, or more generally to provide arbitrary associations of 
unrelated object types. The lookup can occur entirely within the input 
field when it contains all components necessary to do the lookup, 
or alternatively the lookup table can be provided as a separate 
field in  #!F-adobe-times-bold-r-normal--18*   table #!EF . #!N #!N If  #!F-adobe-times-bold-r-normal--18*   table 
#!EF is an array, Lookup treats it as if it has 
an implicit "positions" component with values from 0 to n-1, where 
n is the number of items in the array. Thus if 
the  #!F-adobe-times-bold-r-normal--18*   data #!EF component is integer, and  #!F-adobe-times-bold-r-normal--18*   lookup #!EF 
is an array of strings,  #!F-adobe-times-bold-r-normal--18*   data #!EF can be used 
to lookup a matching value in the implicit positions component and 
return the string. Alternatively, if  #!F-adobe-times-bold-r-normal--18*   data #!EF were also a 
string array, Lookup could lookup a matching value in the  #!F-adobe-times-bold-r-normal--18*   
table #!EF array and return the corresponding implicit position. #!N #!N 
Note: The lookup is done using a binary search of the 
lookup component. If this component is not already sorted, it will 
be internally sorted in order to perform the lookup. Connections are 
not used by this module. Since Data Explorer does not support 
string positions, if lookup is done using a string data type 
the table input must have a separate float positions component. If 
the lookup component has duplicate values, the value corresponding to the 
first one found will be used. #!N #!N Components #!N #!N 
Adds a new component as specified by the  #!F-adobe-times-bold-r-normal--18*   destination #!EF 
parameter containing the looked-up values. #!N #!N Example Visual Programs #!CForestGreen 
#!N #!N  #!F-adobe-courier-bold-r-normal--18*   #!N Duplicates.net #!EF #!N #!N #!EC #!N #!N 
See Also #!N #!N  #!Lcategor,dxall782 h Categorize  #!EL  ,  #!Lmap,dxall891 h Map  #!EL  ,  #!Lcategst,dxall783 h CategoryStatistics  #!EL  #!N #!N 
#!N  #!F-adobe-times-medium-i-normal--18*   Next Topic #!EF #!N #!N  #!Lmngcmpe,dxall887 h ManageColormapEditor  #!EL  #!N  #!F-adobe-times-medium-i-normal--18*   #!N 

