Table of Contents |
---|
minLevel | 1 |
---|
maxLevel | 2 |
---|
outline | false |
---|
style | none |
---|
type | flat |
---|
printable | true |
---|
|
...
This operation returns the values of a given lookup field upon successful key matching.
Info |
---|
Existing lookups required To perform this operation, it is necessary to have existing lookups ready for use (visit this article to get help uploading lookups and this article to get help creating query lookups). |
How does it work in the search window?
...
Argument | Description | Data type |
---|
Lookup name mandatory | Choose the lookup you want to use to enrich your table. | string |
Lookup field mandatory | Choose the lookup field you want to use to enrich your table. | string |
Key mandatory | Choose the table field you want to use to find matches with the lookup key field. | same as lookup key field | Info |
---|
Existing lookups required
To perform these operations, it is necessary to have existing lookups ready for use (visit this article to get help uploading lookups and this article to get help creating query lookups). |
Once you specify the adequate arguments and click the Create field button, the new field is added to your table.
...
select lu("Lookup_name", "Lookup_field", Key_field) as new_field
Info |
---|
Existing lookups required
To perform these operations, it is necessary to have existing lookups ready for use (visit this article to get help uploading lookups and this article to get help creating query lookups). |
---|
Syntax considerations - → This must be the name of lookup that contains the data you want to use to enrich your data.
Status |
---|
colour | Purple |
---|
title | "lookup_field" |
---|
| → This must be the lookup field you want to use to enrich your data, which must not be the same as the lookup key field.- → This must be the table field that will be used to correlate with the lookup key. The name can be different than the lookup key field as long as the data type coincide and the values it contains are potential matches (username-user). The absence of matches will return null and a different data type will return an error when running the query .
|
...