Arranging data based on Hierarchy

[sriniprad08]

Hi Team,

Hope you are well. I need help.

Please find attached the input and expected output.

I would like to keep only the records based on the highest rating (attached the hierarchy).

Please let me know how to go about this,

Thanks,

Sri

[PhilipMannering · Accepted solution]

Something like this should do the trick,

[sriniprad08]

Hi @PhilipMannering ,

Thank you so much for the help. Really appreciate it.

Regards,

Sri

[sriniprad08]

Hi @binuacs ,

Thank you so much for the help. Really appreciate it.

Regards,

Sri

[sriniprad08]

Hi @JarekSkudrzyk ,

Thank you so much for the help. Really appreciate it.

Regards,

Sri

[PhilipMannering]

Anytime 👍

[JarekSkudrzyk]

@sriniprad08 you are welcome!