How to choose the highest value in duplicated summarize output

I am trying to obtain the highest occurrence of a string in within another string. I have gotten close to the end where I have the number of times each string occurs. Now I need to choose the word with the highest count. The image below is a snippet of the end of my workflow. The red boxes show which ones I want to output. I cant seem to figure out where to go from here, anyone have any suggestions?

Tips and Tricks

Transformation

Text Mining

Accepted answers

DataNath

If you add a sort tool and sort Count - Descending, then add a Sample tool, selecting Top N Rows (where N = 1 and Group by Material), is that what you're after?

If not, can you expand a little more? Can't quite think of what the logic is from your explanation, sorry.

philipmannering

@DataNath That retrieve more than the records in the red boxes, no?

All comments

DataNath

If you add a sort tool and sort Count - Descending, then add a Sample tool, selecting Top N Rows (where N = 1 and Group by Material), is that what you're after?

If not, can you expand a little more? Can't quite think of what the logic is from your explanation, sorry.

philipmannering

Hi @oneillp111

So you want the highest count of just the duplicates? See the attached workflow,

highest-count-of-duplicates.yxmd

philipmannering

@DataNath That retrieve more than the records in the red boxes, no?

oneillp111

Thank you, both solutions worked!

DataNath

@PhilipMannering the ones highlighted were the only ones with >1 strings for the same Material so I just assumed it was find the highest if there are multiple.

philipmannering

@DataNath Ah, I see. My mistake. Good point.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703