topic Re: Worflow with Batch Macro in Alteryx Server Discussions

Worflow with Batch Macro

36892362 — Thu, 30 Nov 2023 08:46:05 GMT

Hi Team,

I have created a batch macro and used that in a Process workflow. When publishing the workflow to the Alteryx server to work properly. Should i publish the Batch Macro workflow and the Process workflow using the Batch Macro separately.

Never used a Batch Macro so not familiar.

Re: Worflow with Batch Macro

gawa — Thu, 30 Nov 2023 09:06:18 GMT

@36892362

When you publish Process workflow to the server, go to "Manage workflow assets" and include Batch Macro. No need to publish only Batch Macro itself.

Re: Worflow with Batch Macro

36892362 — Thu, 30 Nov 2023 09:39:06 GMT

Appreicate for the quick response. If i understand it correctly the Both the Macro and Process workflow files can be published together using the Manage workflow Assets Option.

Re: Worflow with Batch Macro

gawa — Thu, 30 Nov 2023 10:21:14 GMT

@36892362 Yes, correct.

Re: Worflow with Batch Macro

36892362 — Fri, 01 Dec 2023 02:26:27 GMT

Thank you 👍. Will give it a try

Re: Worflow with Batch Macro

36892362 — Mon, 18 Dec 2023 06:01:40 GMT

I had made some changes to my batch macro, earlier the Input tool was an excel file with data from one sheet and converted to Macro Input ,

Now using the Dynamic Input tool consolidating the data in three sheets with same schema , this consolidation separately works. But when added to the batch macro and converting the input tool to Macro input it does not work.

Can you anyone advise.

Re: Worflow with Batch Macro

36892362 — Mon, 18 Dec 2023 06:07:17 GMT

when i reconfigured the settings it is working now, but some it is working and sometimes it does not work . What could be the reason

Re: Worflow with Batch Macro

36892362 — Mon, 18 Dec 2023 09:15:50 GMT

Also facing issues to call this macro using dynamic input into another workflow, it is showing errors. If i convert the input tool to Macro input it says record does not provide sheet name. When we use Dynamic input tool in batch macro what tool should be converted to the Macro input