Appending a value to equal the most common used value in a group.

Question

I cant seem to figure this one out...  I have 2 columns, Area and Part.  I am trying to find the most commonly used Area for every Part, and change each Parts Area to match the most commonly used one for that part.  Here is an extremely simplified version of the data.  In reality there are thousands of different parts with hundreds of different areas.

I am getting stuck on how to create the "Adjusted Data" table, I should be able to join/append the data without any issues afterwards.

Any help is greatly appreciated!

Aaron_Harter · Accepted Answer

Hi @arobe14039,

The following logic may help you map your most common area and reach the 'Adjusted Data' table:

T_Willins · Accepted Answer

Hi @Aaron_Harter and @arobe14039,

You can simplify this workflow even further by using Group By Part and Mode Area in the Summarize tool, which eliminates the need for the Sort and Sample tools before the Join.