Batch Macro - Multiple files not reading

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

Workflow

Macros

Common Use Cases

Transformation

Batch Macro

Optimization

Accepted answers

danilang

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

All comments

estherb47

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

danilang

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

jaimonsk

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

Checcc.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703