YOU’RE NOT VIEWING PANDA SECURITY USA. CLICK TO IMPROVE YOUR EXPERIENCE
VISIT PANDA SECURITY USA
x
48h OFFER
If you're already a customer of
our homeusers protection,
renew now with 50% off
RENEW NOW
x
48-HOUR OFFER
50%
RENEWALS
Home users only
RENEW AT A DISCOUNT
x
SPECIAL OFFER
If you're already a customer of
our homeusers protection,
renew now with 50% off
RENEW NOW
x
HALLOWEEN OFFER
take advantage of our
terrific discounts
BUY NOW AND GET 50% OFF
x
SPECIAL OFFER
Buy the best antivirus
at the best price
BUY NOW AND GET 50% OFF
x
SPECIAL OFFER
Buy the best antivirus
at the best price
BUY NOW AND GET 50% OFF
x
UP TO
-60%
BUY NOW
x
UP TO
-60%
BUY NOW

Technical Support

Need help?

 

How to add external data to an existing table in Advanced Reporting Tool

Information applies to:

Products
Adaptive DefenseAdaptive Defense 360
Adaptive Defense 360 on Aether PlatformAdaptive Defense on Aether Platform

The Lookup Tables feature allows administrators to add external data to an existing data table by correlating the table with a data file that contains the new fields to be appended to it (lookup file).

A common use case is to group computers or users into categories or profiles. To do that, you have to generate a lookup file with the list of computers and users as the first column, and the categories or groups in the subsequent columns.

A lookup file must meet the following requirements:


It must be a CSV file with the following characteristics:

  • The first column is the key to be used to perform the join operation with an existing column in the table to extend.
  • The other columns will be the values that can be used to extend the table.
  • The values in the first column (the key) must be unique. The first column cannot have duplicate values. Otherwise, the process will be aborted.
  • The columns must be separated by the comma character.
  • Do not include special characters (quotation marks, accents, apostrophes, etc.).
  • The file must have a maximum size of 2 GB.
  • You can add as many columns to the first one (the key) as you want. For example: category1, category2. Or category, country. Or group1, group2. Or flags: active (yes/no), corporate (yes/no).

The tool to use to upload this file (the lookup file) can be found in the Search area:



Suppose you have a CSV file with the following information:

IP,StreetAddress,Building,Floor,Office,Brand,Model

160.10.75.133,Mainstreet 12,A,4,12,Canon,ZX150

85.197.192.19,Mainstreet 13,A,4,14,HP,MJF55

164.6.193.160,Mainstreet 14,A,5,44,Canon,CC232

33.150.178.1,Mainstreet 15,A,5,23,HP,Laserjet 11

171.59.193.17,Mainstreet 16,A,7,5,HP,LT66

10.0.73.16,Mainstreet 17,A,8,6,Canon,BigPriter32

10.0.73.17,Mainstreet 18,A,9,12,Brothers,Yeah64

To upload the lookup file, go to Search, Lookup Management (in the top right-hand corner of the screen). Click New Lookup and fill out the required fields:


The file will be uploaded to the system in a few minutes and you'll be able to add the columns to an existing table. To do that, open the table to extend as if you were going to make a query. Select Create Column, and Custom in Operation.


Opening the operation drop-down menu will display as many functions as secondary columns were included in the uploaded lookup file.

Select one of them. The result will be a new column, whose name will be the same as that of the column in the lookup file, added at the end of the table.



Repeat this process for the remaining columns. The new columns will admit the same operations as those in the original table: they can be filtered, grouped, included in charts, etc.

We advise that you keep a copy of the last uploaded lookup file for each Lookup table that you are managing, as you will not be able to view the contents of the table once it has been uploaded to Advanced Reporting Tool.



Help nº- 20170811 50108 EN

Have you resolved your query with this article?

yes no

Thanks for your answer


Why didn't you find it helpful?


The instructions are too complex.
The instructions are too long.
The instructions don't work.
I'd rather have a video.
Other reasons.




Talk to a technician!

 

Business hours: Mondays-Fridays 9:00 to 18:00 CET

Outside business hours, please use the online form.





ALWAYS ONLINE TO HELP YOU TWITTER FORUM RATE US CHAT
ALWAYS ONLINE TO HELP YOU TWITTER FORUM RATE US CHAT