Can I make two lookup tables that specify the same output field name?

[xvxt006]

Hi,

i have individual IPs and then CIDR blocks that i want to look up and group them using a look up table. I am assuming i cannot have both in the same .csv file as i have to add match_type = CIDR(clientip). Then it won't match the individual ips ( 63.158.163.8,64.274.165.6 in the list below). So i created 2 look up tables one for CIDR and one for individual IPs. Both of them i have output field as "Name". Question is would that work? is it possible to have same output field name in both the lookup tables? ideally i would like to have same Output name.

Name            clientip
Company XXX     63.122.163.0/27 
Company YYYY    63.158.163.8
Company YYYY    64.274.165.6 

[Ayn · Accepted solution]

You don't need to have two separate lookup tables. Individual IP addresses can also be CIDR notated. The bitmask would be /32 (i.e. matching all the bits). So for instance instead of 63.158.163.8 write 63.158.163.8/32.

[xvxt006]

Oh i just saw this response from my other thread. For some reason i did not get the email notification Ayn (which i generally get). Thanks for your help. I am not familiar with these CIDR formats. I will read it. Thanks for your help.

[Ayn]

Are you familiar with how to notate networks in CIDR format? If you're not I suggest you go read up on it before using it in a lookup 🙂

63.123.45.* would be equivalent to 63.123.45.0/24 (3 octets filled --> 3*8 = 24) and 63.123.* equivalent to 63.123.0.0/16 (2*8 = 16)

[xvxt006]

For some reason in the above comment it is not showing star after the dot

[xvxt006]

Thank you Ayn. I did not know that. One other question i have around IPs is, if i have IPs like 63.123.45.* or 63.123.* something like that, how can i use them in lookup table?