Upload a lookup table

[ 1 About upload lookups ] [ 2 What permissions do I need? ] [ 3 What type of data can I use? ] [ 4 Creating the new upload lookup ] [ 5 Finding your uploaded lookup ]

About upload lookups

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 the View version of the Lookups permission. However, the Manage version is required to create lookups by uploading files. Having the User resources permission is equivalent to having the Manage version of the Lookups permission.

Notice that at least the View version of the Finders permission is required to enable the Lookup permission (know more about permissions here).

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 of 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`	IPv6 address	`IP6`
Net4 (IPv4 CIDR)	`net4`	Net6 (IPv6 CIDR)	`net6`

Data type translations

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

Problems with escaped characters

Escaped characters can cause parsing issues. To avoid this, do not include strings with escaped characters in CSV files.

For example, the following CSV snippet contains escaped characters that lead to parsing problems:

name,description,id,json
"name1","desc1",111,"{\"key\":\"value1\"}"
"name2","desc_2",222,"{\"key\":\"value2\"}"
"name_3","desc3",6009,"{\"key\":\"value3\"}"
"name_4","desc4",6007,"{\"key\":\"value4\"}"

The correct format would be:

name,description,id,json
"name1","desc1",111,"{""key"":""value1""}"
"name2","desc_2",222,"{""key"":""value2""}"
"name_3","desc3",6009,"{""key"":""value3""}"
"name_4","desc4",6007,"{""key"":""value4""}"

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:

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.