We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Batch Macro not giving required output

pareshmongia
5 - Atom

 Hello,

 

I am using a batch macro where in I have used a single control parameter and 14 update tools which replaces the filename in the path for 12 input tools , 1 Output tool  and 1 update tool replacing a value in a filter.

 

This macro when run with the default values gives me the required output. however when i used it after inserting it as a macro in a new workflow and passing a list of 24 values, it runs without errors but the files generated in the output files are having 0 rows except for the default value used in the macro.

 

Can someone Please help me with the issue.

3 REPLIES 3
apathetichell
20 - Arcturus

Most likely culprit -> your action tools are configured wrong. Post screenshots of the configuration. Include the replace a specific string

Having said that-> one control parameter= one field from your outer workflow. That's it. 14 fields = 14 control parameters.

 

If you have the same field being updated 14 times for a path-> I'd recommend creating this somewhere in your macro once-> and using append fields to get this into your main workflow.

pareshmongia
5 - Atom

Thank you apathetichell. I have made the necessary changes. The actual problem was the update tool incorrectly configured for the filter tool. The macro is now working as required.

apathetichell
20 - Arcturus

Cool -Please mark my recommendation as a solution.

Labels
Top Solution Authors