Help running iterative process through data table

[cpease]

Hello,

I am fairly new to Alteryx and I am looking to build a workflow that will work through a table of data and run a process based on a state parameter. In this example, I am looking to call out the highest variances by state (3 records per state). However, the states in the data table will be different based on parameters that are passed earlier in the workflow.

State	Company Name	Variance
NY	A	$1000
NY	B	$500
NY	C	$200
NJ	D	$20000
NJ	E	$1000
NY	F	$100
CA	G	$10000

Appreciate the help!

[griffinwelsh]

See the attached workflow for a solution. This is a usecase for group by rather than a batch macro. 

[SPetrie]

If that is what your input looks like, I think a macro is a bit overkill.

One option, If your variances are Numeric, you can sort them descending and then use a sample tool grouped by state to take the first 3.