Pass value to update filter

[gwiz]

I get a count of a number and want to pass that count to my criteria to filter on (in a filter tool). This wont be the field (which will always be the same) but the criteria/value. Is there a way just to have the workflow/macro automatically update that field with the value as the count may change?

[fmvizcaino]

Hi @gwiz ,

This is a quick example showing how to get that done.

I've created a batch macro and the input file is inside of it controlled by a count column from outside.

Let me know if that works for you.

Best,

Fernando Vizcaino

[gwiz]

@fmvizcaino thank you for posting that. While that would work logically if I was passing the value from outside the macro, I am actually trying to pass a count of a value within a macro. So I take a count of a field and then I'd like to within the macro pass that through to the filter. I would like to pass the count from that summarize to update the value in the filter but cant figure out how

[fmvizcaino · Accepted solution]

Hi @gwiz ,

Take a look at my example and see if that makes sense to your needs.

Best,

Fernando Vizcaino

[gwiz]

That was easy, thank you for making it so simple! I knew there was a solution. I was overthinking it.

You are a good friend

[stapuff]

@fmvizcaino 

Your example helped me out!

Thanks,

Puff