If condtion order

[rmartinez4]

Hi All,

I have ranking process that I want to solve. I have a final data table in my workflow which contains a Unique ID called Hostname. with 4 attributes (Columns) for each tool I used  IP, OS, MAC Address, and Last Date. Now the columns with Hostname is static but I have a column for each tool as I stated.

Hostname - IP.Sun, OS,Sun,  Mac Address.Sun , Last Date.Sun, IP.Earth, OS.Earth, Mac Address.Earth, Last Date.Earth, IP.Mars, OS.Mars, Mac Address.Mars, Last Date.Mars

Then I have a ranking order below and I want to make a final table  (Now some might be null or blank since they don't always contain data 

Hostname   IP Ranking        OS                 MAC Address      Last Date

 Test1              1.Sun             1.Mars             1.Sun                       1.Mars

 Test2              2.Mars           2.Sun               2.Mars                     2.Earth

 Test3              3.Earth           3.Earth            3.Earth                     3.Sun

I think this could be done with IF conditions  with my ranking order above

Final Result table based off my ranking if blank go the next ranking order or just give me "Not Found"

Thank You- I hope my explanation of problem is helpful

[Ladarthure]

Hi @rmartinez4,

I am not sure to understand what you expect. To help us around, would you be able to share the start file and the expected output?