Help needed in filtering the data and writing a output as excel file and repeat the same

Question

Hi All,

I am new to Alteryx, I am trying to filter data dynamically and write output in excel and repeat the same process for all the records in Filter table. I have uploaded the workflow and macro. It would be great if someone can help in identify what is wrong with the attached workflow.

Dynamic Filter and multiple output.zip

afv2688 · Accepted Answer

Hi @GopalR ,

You almost had it. On your macro change the action tools as following:

On your filter:

On the output:

Cheers

afv2688 · Accepted Answer

Hello @GopalR ,

Are you sure you have done the modifications as I showed them? It is working for me fine.

Check first that the checkboxes are as in my images (unchecked)

UPDATE: Noticed that on my screnshot it is not seen, but the 'Update a specific string' box in my action tool on the filter tool is unchecked. Sorry for not showing it.

cheers