Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Batch tool with filter

suzi123
5 - Atom

Hi all - I'm building a batch tool where I need the filter condition to change during each batch. However, the filter condition is not changing, and I can only filter for the placeholder filter I originally had in my macro. I would appreciate any guidance. Thanks!

2 REPLIES 2
DavidSkaife
13 - Pulsar

Hi @suzi123 

 

Are you able to share the workflow/macro and some sample data at all?

JamesCharnley
13 - Pulsar

Hey @suzi123 

 

It's a little difficult to diagnose the exact issue without a screenshot or workflow, but my best guess is you don't have an action set up correctly.

 

1. You're going to want to create a connection from your control parameter to the lightning bolt anchor of your filter tool, which should automatically add an action tool.

2. Within the configuration of that action tool, you're going to want to open up the menus until you get an option to change the current value in your filter. If memory serves this will say something like 'Expression - value =' followed by your expression.

3. Then you're going to want to tick the box at the bottom of the configuration menu that says 'Replace a specific string', making sure it's only the value you're replacing within the formula (ie the batch), and no other parts including the '   ' as well.

 

This means that when your control parameter is being batched in, it will replace and update the value in the filter.

 

I don't have access to alteryx right now to mock something up but if you still need some more guidance tomorrow I should be able to help if nobody else has.

Labels