Category
Transformation
Function
Syntax
output = Lookup(input, table, data, lookup, value, destination, ignore);
Inputs
| Name
| Type
| Default
| Description
|
| input
| field, string list, value, value
list
| (none)
| object to lookup
|
| table
| field, string, value list
| (dataname lookup)
| lookup table
|
| data
| string
| "data"
| component of
input to lookup
|
| lookup
| string
| "positions"
| component of
table in which to look
|
| value
| string
| "data"
| component in
table containing lookup results
|
| destination
| string
| "lookedup"
| component of
input in which to put result
|
| ignore
| string list
| (no default)
| Properties to ignore in string
lookup
|
Outputs
| Name
| Type
| Description
|
| output
| field or array
| field or array with looked-up
values
|
Functional Details
input
| field containing the component to use as lookup
|
table
| field containing the lookup table components
|
data
| component in input to use for looking up
|
lookup
| component in table that the data component is to match
|
value
| component in table to use as the looked up result
|
destination
| component of input in which to put the looked up results
|
ignore
| 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). ignore can be a list of
strings; for example, a commonly used combination
is {"space", "case", "punctuation"}.
|
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
table.
If table 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
data component is integer, and
lookup is an array of strings,
data can be used to lookup a matching value in the
implicit positions component and return the string. Alternatively, if
data were also a string array, Lookup could lookup a
matching value in the table array and return the
corresponding implicit position.
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.
Components
Adds a new component as specified by the destination
parameter containing the looked-up values.
Example Visual Programs
Duplicates.net
See Also
Categorize,
Map,
CategoryStatistics