IP Source & Destination names - lookup from same table

[exfosteve]

I have a  table of IP addresses to IP Names, and a table of  srcIP and dest IP addresses, where both source and destination IPs are in the first table.

Table 1 -  IP Address, IP Name

Table 2 - Source IP,   Destination IP

I want to build a table chart like this.

source IP, source name, dest IP, dest Name

Where both source name and dest name get their values from Table 1.

What's the best way to do this?

[jwjackso]

I would use a mapping table in the load script, something similar to below:

MAP_IP:

load

Mapping

[IP Addresses],

[IP Names]

from FileName;

IP_Addresses:

Load [Source IP],

         ApplyMap('MAP_IP',[Source IP],Null()) as Source_IP_Name,

        [Destination IP],

        ApplyMap('MAP_IP',[Destination IP],Null()) as Destination_IP_Name

from FileName;

[exfosteve]

Thanks.  I was trying to avoid mapping.  I wasn't clear in my original statement.  The IP address and name table actually has a lot more entries regarding (address, owner, etc.). I  want a key that will link both src and dest IP address in table 2 to all of the ip data content in table one.  I basically want to have both src and dest IP share a common key to the ip address in table one.

[balabhaskarqlik]

Rename column name in Table1.