How to select specific row with dynamic criteria

[zqlcancer]

In below sample, I need select rows which number in column 'Index' is the maximum number of entire column 'Index'. i.e. in this example, I need select rows which number of 'Index' column is 8(lines marked in red). Is this possible in Alteryx with dynamic selection criteria?

Index	Name
8	Mike
8	Mary
6	Mike
6	Tom
2	Mike
2	Tina

[caltang · Accepted solution]

Best way I know:

[ChrisTX]

Use a Summarize tool to find the Max Index.  Join the output from the Summarize back to your original data.

If you're new to Alteryx, check out Learning Paths and Interactive Lessons under Learn > Academy.

Chris