Group by Material and Filter

[nicktekippe]

I need Alteryx to filter this data by identifying which Task_Code_2 "0030" or "0021" appears more in the data for each part number that will show up in the data.

In the example below I would want Alteryx to leave me with just one row for the material R553250 with the most common Task_Code_2 being 0030

[Felipe_Ribeir0 · Accepted solution]

Hi @nicktekippe 

One way of doing this, just replace the input for your input to test it

[gautiergodard]

Hey @nicktekippe 

Here is one way you could do this:

[PanPP]

Hi @nicktekippe 

I have uploaded a sample WF.