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

IP Source & Destination names - lookup from same table

exfosteve — Wed, 25 Nov 2020 16:16:04 GMT

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?

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

jwjackso — Wed, 11 Jul 2018 22:12:15 GMT

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;

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

exfosteve — Thu, 12 Jul 2018 16:19:40 GMT

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.

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

BalaBhaskar_Qlik — Fri, 13 Jul 2018 07:20:39 GMT

Rename column name in Table1.