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.
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.
