...
Users with the necessary permissions can upload CSV files to create lookup tables. To upload them, you need to do it in the Lookup Managementmanagement tab of the Data Searchsearch area.
...
What permissions do I need?
To access this area, you need to have at least view permissions on Lookupsthe View version of the Lookups permission. However, you will not be able to upload files to create lookups unless you have the management version of that very same permission.
...
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 on each data type format.
Name | Data type | Name | Data type |
---|---|---|---|
Alphanumeric value |
| Hexadecimal number |
|
Integer number |
| Long hexadecimal number |
|
Long integer number |
|
|
|
Floating point number |
| IPv6 address |
|
Net4 (IPv4 CIDR) |
| Net6 (IPv6 CIDR) |
|
Info |
---|
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:
...
title | Click here for the CSV file of the example |
---|
View file | ||
---|---|---|
|
Rw ui steps macro | ||||||||
---|---|---|---|---|---|---|---|---|
In the Data Search → search → Lookup Managementmanagement area, click New Lookuplookup at the top right.
Enter a name for the lookup, such as IP_list, and drag the file onto the field (or click Browse and select the CSV file).
Check the Contains headers box to specify that the first row must not be considered as values and thus must be skipped when parsed.
Give each field the desired name and format, and then choose the desired key field by marking the Is key option at the end of its row.
Click Create Lookuplookup. You will receive a notification when the file is uploaded. Note this may take a few minutes. 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 Searchsearch → Lookup Managementmanagement. 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 Searchsearch → Explore Your Datayour 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.
...