Trying to create a simple batch marco to filter out small values

[BSmithdubz]

Hey all, 

Noob question here, I am trying to create a batch macro to filter data based on two conditions. Essentially, I have to first filter by the ACA field, and then filter out any values below a certain recorded investment amount, varying by the ACA and recorded investment control parameters. The goal of the final output is then to bring all that data back together in the final output. My output seems to be returning values of any amount for every ACA. I've included pictures of the workflow, the control parameters, and the macro. Unfortunately there's some private data but can drop some fake data in here as the input if the fix isn't easy to see. 

Thanks!

[messi007]

Dear @BSmithdubz,

Could you please share the macro, the data (Sample Fake) and an example of the desired output.

I will be happy to help 🙂

Regards,

[BSmithdubz]

Here it is - there were some errors moving over to dummy data, but it should essentially be the same problem to fix. Thanks!

[messi007 · Accepted solution]

Dear @BSmithdubz,

Below what I understand and correct me if I'm wrong.

you want to batch in the first column to fiter by ACA and batch the value as well in order to be bigger then the value in the batch

Below the macro

Below the result of the workflow

Attached the workflow.

Please marke it as solved if the solution is okay 🙂

Regards,