IF conditions

[rmartinez4]

Hi I want to remove a Hostname that appears for example below 3 or any amount of time with an IP but I only need one with an IP. I don't care which one stays but I will like to keep the one with an IP and last resort the one with Not Found if no IP was found. I have duplicates with IP I prefer to keep 1 unique hostname with 1IP or keep the unique hostname with IP "Not Found".

[Qiu]

@rmartinez4 
I am sorry but I was not able to understand your intention here.
maybe you can provide a sample output based on your input?

[rmartinez4]

I want to keep 1 hostname of the test1 with column IP.  The rest can drop in the workflow. Now if the Hostname only has an IP with Not Found then must give me that row. Not sure how the logic will be. I just need 1 unique Hostname for all Hostname preferably with an IP number.

[rmartinez4]

Sorry I just provided an example with a single digit number in IP. 

[Qiu]

@rmartinez4 

Maybe I am wrong?

[rmartinez4]

I will many duplicates of Hostname but I don't want to lose the one that has an IP.

[Qiu · Accepted solution]

@rmartinez4 

Please just give a sample output.

[rmartinez4]

I figured it out I just need to ensure I have sort because unique will only take the first duplicate it finds and since not found while using ascending in the sort tool. I should be good thanks.