.Upload a lookup table vv7.0.8
- Borja Moro Moreno
- Anthony Shevlin (Deactivated)
Suppose you have the following CSV file containing printers' information and their corresponding IPs and addresses:
| IP,StreetAddress,Building,Floor,Office,Brand,Model | |||
| 87.153.102.201,Mainstreet 12,A,4,12,Canon,ZX150 | |||
| 85.197.192.19,Mainstreet 18,A,4,14,HP,MJF55 | |||
| 164.6.193.160,Mainstreet 65,A,5,44,Canon,CC232 | |||
| 33.150.178.1,Mainstreet 15,A,5,23,HP,Laserjet 11 | |||
| 205.118.111.66,Mainstreet 46,A,7,5,HP,LT66 | |||
| 10.0.73.16,Mainstreet 17,A,8,6,Canon,BigPriter32 | |||
| 205.118.113.53,Mainstreet 38,A,9,12,Brothers,Yeah64 |
If you want to upload the file as a lookup:
- Go to Data Search → Lookup Management and click New Lookup.
Enter a name for the lookup (in this case, IP_list), then click Choose file and select the CSV file. Check the Contains headers box.
New Lookup table names cannot be created using the hyphen ( - ) character. This character was previously allowed; thus you may find old Lookups containing a hyphen. Query Lookup table names, however, can contain hyphens.- Choose a key column selecting the Is key option. In this example, the key will be the IP column.
- Click Upload. You will receive a notification when the file is uploaded. Note this may take a few minutes.
Repeated values in the key column
The column selected as key upon the lookup definition should not contain repeated values. If so, only the last value in the file will be kept, and the rest of the events with that value repeated will be discarded.
For example, if you upload the following CSV and select the column user as key, only the second event that contains Mike will be kept.
Once uploaded, you can find the lookup in:
- Data Search → Lookup Management, where you can manage and edit your lookup tables. The lookup table will be ready when the indicator in the Status column turns green.
- Data Search → Explore Your Data if you choose my → lookuplist, where you can open lookups as data tables and apply operations.
Now you can add the required columns in your lookup table to a query. See Add lookup values to your query to learn how to do it.