Hi @PickleRick Sorry I missed another condition. I also updated the initial post. The name0 is not in order. The dedup/filter should not be applied to IPs that doesn't contain "name0" AND it shou...
See more...
Hi @PickleRick Sorry I missed another condition. I also updated the initial post. The name0 is not in order. The dedup/filter should not be applied to IPs that doesn't contain "name0" AND it should not be applied to unique IP that has "name0" So, unique IP like 1.1.1.5 and 1.1.1.6 that has "name0" needs to be remained in the data. What I did now is to filter out statically, but another IP could show up with the same pattern. Thank you again for your help Data: ip name location 1.1.1.1 name0 location-1 1.1.1.1 name1 location-1 1.1.1.2 name2 location-2 1.1.1.2 name0 location-20 1.1.1.3 name0 location-3 1.1.1.3 name3 location-3 1.1.1.4 name4 location-4 1.1.1.4 name4b location-4 1.1.1.5 name0 location-0 1.1.1.6 name0 location-0 Expected output: ip name location 1.1.1.1 name1 location-1 1.1.1.2 name2 location-2 1.1.1.3 name3 location-3 1.1.1.4 name4 location-4 1.1.1.4 name4b location-4 1.1.1.5 name0 location-0 1.1.1.6 name0 location-0 | makeresults format=csv data="ip, name, location
1.1.1.1, name0, location-1
1.1.1.1, name1, location-1
1.1.1.2, name2, location-2
1.1.1.2, name0, location-20
1.1.1.3, name0, location-3
1.1.1.3, name3, location-3
1.1.1.4, name4, location-4
1.1.1.4, name4b, location-4
1.1.1.5, name0, location-0
1.1.1.6, name0, location-0"