Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

exfosteve
New Contributor II

IP Source & Destination names - lookup from same table

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?

3 Replies
jwjackso
Contributor III

Re: IP Source & Destination names - lookup from same table

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
New Contributor II

Re: IP Source & Destination names - lookup from same table

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
Honored Contributor

Re: IP Source & Destination names - lookup from same table

Rename column name in Table1.