Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Batch Macro only reading 1 input file inside macro

mosellecu
5 - Atom

I have created a batch macro that should be able to read input files with different field schema from the directory it feeds from (main workflow). however, when placing in the workflow, there is no error but it incorrectly reads the 1 input file that is in the macro, and not the file/s that I have placed in the directory. this sample file in the macro is already deleted from the directory, so I don’t know why it has still been reading it.

 

The actions i tried for this were “Update Input Data Tool” as well as “Update Value (Default” and highlighted the “file” portion and clicked replace string but still encountered the same issue.

 

Please help troubleshoot, thank you so much!

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@mosellecu 
It will be much better if you can share the workflow so we can take a  closer look.

Based on your description, your batch macro is not working, and the only read-in is most likely the dummy data inside the macro itself.

JamesCharnley
13 - Pulsar

@mosellecu  something this could be is not having any tools attached to the macro downstream. Frustrated me no end when it first happened to me and thought it was an issue with my macro!

 

For example, here is a batch macro I made for a weekly challenge. It's supposed to output 10 tables. When there's nothing downstream, it stops running after 1.

 

JamesCharnley_1-1674466184293.png

 

If I just add a Browse tool as an example, it runs the expected 10!

 

JamesCharnley_2-1674466214769.png

 

Edit: Looks like I didn't read the Q properly but I'll leave this up in case it's useful. As Qiu said maybe in this case some screenshots would help if the action isn't working correctly?

mosellecu
5 - Atom

Thanks @Qiu and @JamesCharnley. The macro is reading the correct file, but it is not appending the fields I want it to read based on the sample input file inside the macro have their values as null. 

Labels