topic Re: Batch Macro - Multiple files not reading in Alteryx Designer Desktop Discussions

Batch Macro - Multiple files not reading

jaimonsk — Fri, 20 Sep 2019 10:49:17 GMT

Hi Experts,

I was building a batch macro with 6 csv file inputs. This macro needs to be batched multiple times based on a column which is another input for this macro. But when I run the the macro, it is not reading any of files which I'm pointing in the interface of the macro. Could someone help me on this?

P:S: Due to some organizational policies, i could not share the workflow. Sorry for the confusion

Re: Batch Macro - Multiple files not reading

estherb47 — Fri, 20 Sep 2019 10:51:00 GMT

Hi,

Without seeing any of the macro, it’s really hard to diagnose what isn’t working.

General comments - make sure you’re configuring the macro correctly from the workflow that runs it. For different scheme in the files, make sure the macro configuration is set up to accommodate that by enabling reading in files with different columns (interface window). Make sure you have a control parameter or macro input set up for the files to be read.

Those are some out of the blue guesses.

Cheers,
Esther

Re: Batch Macro - Multiple files not reading

danilang — Fri, 20 Sep 2019 11:10:40 GMT

Hi @jaimonsk

Another point to add to @estherb47's suggestions. The macro will only run one iteration when you test it in the .yxmc in Designer, with the values that you've set in the tools. It's only once you embed the macro in a calling program that the Control parameter and interface elements come into play.

Dan

Re: Batch Macro - Multiple files not reading

jaimonsk — Fri, 20 Sep 2019 11:28:05 GMT

Hi @estherb47 and @danilang

Thanks for your time!

Here i'm attaching a screenshot of the file input updation inside the macro
could this help you in understanding the error inside the macro

Re: Batch Macro - Multiple files not reading

danilang — Fri, 20 Sep 2019 11:35:54 GMT

Hi @jaimonsk

Add a Message tool right after the tool that this Action tool updates and set it to display the updated path. This will give you confirmation that the path is actually correct on each iteration of the macro. In order to see this in your calling program, you'll have to ensure that that Show all macro messages is checked.

Dan