First Batch Macro help

I'm trying to use my first batch macro, because I have a workflow pulling files from a folder and there are too many for individual inputs. Additionally, I continue to get the "Different schema" error for 4-5 files, no matter how many times I've tried to save the formatting over.

I am using the batch macro from this page - https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

After opening the Alteryx package, I have updated the path for the Directory Tool Input to my folder.

I have also opened the macro and updated the path for the input tool placeholder. This seems to have updated the File Value on the Update Value tool.

However, when I run it, it gives me an error - Error: Batch Correct (2): Record #1: Tool #1: Unable to open file for read: Sheets\.849C9593-D756-4E56-8D6E-42412F2A707B

It seems like it's aimed at the correct folder but it's trying to read something else - maybe the example data that came with the macro?

I've attached screenshots if it helps (I deleted parts of file path names as needed)

batch1.png

batch2.png

Workflow

Preparation

Accepted answers

alexnajm

Make sure the list of files from the Directory tool are only Excel files

zachritter00

I seem to have figured it out.

When changing the file path for the Directory Input Tool, I was not updating the File Specification. For some reason, when it remained *.*, I got the error above referencing an unreadable file "\.849C9593-D756-4E56-8D6E-42412F2A707B"

I updated the File Specification to *.xlsx, and it seems to be working fine now. Not totally sure why it didn't like *.*, but I'm going to leave this up with a screenshot for future users. Thanks for your help on this.

solution.png

All comments

alexnajm

Make sure the list of files from the Directory tool are only Excel files

alexnajm

Otherwise yes you can try changing the Input Data tool in the macro to a file that exists on your machine

zachritter00

Everything in the folder is an .xlsx file. It's a shared network folder.

The Workflow is on my computer. I downloaded the file from that Alteryx Learning site I posted, it's in my downloads folder. Not sure how important that is but wanted to cover everything.

Changing the input on the Input Data Tool was giving me the error I posted, after I read your reply, I deleted the Input Data Tool and put in a new one and referenced the same folder and got the same error.

alexnajm

It’s hard to tell then what’s going on without more information - I have downloaded the same attachment numerous times and it has been successful.

You can rebuild it from scratch then since it’s only four tools and use that new macro in your workflow. Otherwise you’ll have to provide more to help - screenshots of each of your configs and data, the workflow with the macro, etc.

alexnajm

Main thing to consider - is the Action tool making the update it needs to be doing?

zachritter00

I seem to have figured it out.

solution.png

alexnajm

Fantastic. That is related to my first reply if you could also mark my response is a solution, it would be greatly appreciated. Thanks in advance!

zachritter00

Ah, I see that now - I misread it originally while I was trying to understand the batch macro. Thank you again.

alexnajm

No problem!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703