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
Hi @sriniprad08
You want to attach a numerical rating > Sort the data > Sample the first one per Country. See attached,
@sriniprad08
Hi, try assigning numerical value and using join tool. Then group by country and select max value - see my example solution.
Hi @binu_acs @JarekSkudrzyk @PhilipMannering ,
Thank you so much. Perfect. It works. I need one more help.
I have now more than one column . Please find attached how to go about that please.
Thanks
As I can't be bothered typing the whole table out, as you've posted a picture of the data and not the data itself, I'll just explain that you need to Transpose your Catg columns. Then do exactly the same thing as my workflow I posted above.
Something like this....
Hi @PhilipMannering ,
Sorry i didnt attach the data. Please find attached,
Something like this should do the trick,
Please find the sample output
Thank you so much for the help. Really appreciate it.
Regards,
Hi @binu_acs ,
Hi @JarekSkudrzyk ,
Anytime 👍
@sriniprad08 you are welcome!
