IF conditions

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".

Transformation

Accepted answers

Qiu

@rmartinez4

Please just give a sample output.

All comments

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.

Maybe I am wrong?

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

Qiu

@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.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177