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]

Hi @sriniprad08 

You want to attach a numerical rating > Sort the data > Sample the first one per Country. See attached,

[JarekSkudrzyk · Accepted solution]

@sriniprad08 

Hi, try assigning numerical value and using join tool. Then group by country and select max value - see my example solution.

[binuacs · Accepted solution]

@sriniprad08 

[sriniprad08 · Accepted solution]

Hi @binuacs  @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

Sri

[PhilipMannering · Accepted solution]

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.

[PhilipMannering · Accepted solution]

Something like this....

[sriniprad08 · Accepted solution]

 Hi @PhilipMannering ,

Sorry i didnt attach the data. Please find attached,

Thanks,

Sri

[sriniprad08]

Hi @PhilipMannering ,

Please find the sample output

Thanks

[binuacs · Accepted solution]

@sriniprad08