Hello all,
I can't figure out how to build a lookup with a condition. I have the following table which is my base search:
SubnetName ip_address
Subnet_ABCD 10.177.99.53
Subnet_1234 10.8.183.3
Subnet_1234 10.8.182.233
Subnet_ABCD 10.177.83.244
And the following lookup table:
Last_SubnetName SubnetID NetStart NetEnd
Subnet_A 10.177.0.0/16 10.177.0.1 10.177.255.254
Subnet_B 10.8.0.0/16 10.8.0.1 10.8.255.254
Subnet_B 192.16.0.0/24 192.168.0.1 192.168.0.254
This is the closest I got after reading several articles, but as you can see, I got no luck. The result is simply blank every time I try it.
index=mybasesearch ( [| inputlookup myLookupTable.csv | table Last_SubnetName,SubnetID,NetStart,NetEnd ] AND last_ip_address
>=NetStart AND last_ip_address<=NetEnd)
Need your help to proceed.
