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