Document toolboxDocument toolbox

Upload a lookup table

Users with the necessary permissions can upload CSV files to create lookup tables. To upload them, you need to do it in the Lookup Management tab of the Data Search area.

What permissions do I need?

To access this area, you need to have at least view permissions on Lookups. However, you will not be able to upload files to create lookups unless you have the management version of that very same permission.

What type of data can I use?

When creating a new upload lookup, the CSV file you intend to upload may contain data in the formats listed below. Data in other formats will not be recognized and thus not offered as an option to choose in the lookup creation window. Visit Data types in Devo for examples on each data type format.

Name

Data type

Name

Data type

Name

Data type

Name

Data type

Alphanumeric value

String

Hexadecimal number

Hex4

Integer number

Int4

Long hexadecimal number

Hex8

Long integer number

Int8


IPv4 address


IP4

Floating point number

Float4

Data type translations

As a result of standardization procedures, some of these data types are translated when the lookup in created. Hexadecimal, for example, will be shown as Int.

Creating the new upload lookup

Suppose you have the CSV file below containing printers' information and their corresponding IPs and addresses, which we want to use to create a lookup table to later use for data enrichment. If you want to upload the file as a lookup:

Now you can add fields from your lookup to a query in order to enrich it with additional information. See Add lookup values to your query to learn how to do it.

Finding your uploaded lookup

Once uploaded, you can find the lookup in:

  • Data Search → Lookup Management. Here you can manage and edit lookup tables (visit this article to know more). The lookup table will be ready when the indicator in the Status field turns green.

  • Data Search → Explore Your Data. Select the tags in the finder my.lookuplist.<lookupname> to open lookups as data tables and apply operations as you would do with any other data table.