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

[GopalR]

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.

[afv2688 · Accepted solution]

Hi @GopalR ,

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

On your filter:

On the output:

Cheers

[GopalR]

Thanks for your support!

I have tried it as you advised , If I run the macro alone, I get the single Input in Excel file, But when I try with the workflow again I am getting the Parse tool error without any output.

Regards,

Gopal

[afv2688 · Accepted solution]

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

[GopalR]

It's working fine.. Thank you so much for your support... Appreciate your time! :)