Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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.
Rename column name in Table1.