#!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
Generated by dwww version 1.15 on Sat Jun 22 12:46:13 CEST 2024.