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?
Solved! Go to Solution.
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.
@DataNath That retrieve more than the records in the red boxes, no?
Thank you, both solutions worked!
@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.
@DataNath Ah, I see. My mistake. Good point.