Troubleshooting Batch Macro

Hello,

Could someone please help me understand why 1 of these two macros is not working? I found the top macro on the Alteryx Forums for importing multiple sheets and files at the same time, and the bottom macro was my attempt at rebuilding them to understand the logic behind it. Both versions of the macro look the same to me, so I am not sure why mine it is not working. So just a few question:

(1) What do I need to update on the bottom macro so I can get it do work like the top?

(2) If I am only using 1 input file, what do I need to do to adjust macro / workflow so I don't need to use the directory tool and can instead use the standard input tool?

Thanks,

Frazer

workflow.yxzp

Developer

Custom Tools

Best Practices

Batch Macro

Accepted answers

Qiu

@The_Fray
That is a bit strange. It works on my side.
Anyway, I attached the workflow here for your test. And for your 2nd question, I have also prepared as below.

workflow-01.yxzp

All comments

Qiu

@The_Fray
I think you are missing the "Replace a specific string" part.
Try to configure that also comparing with the test.yxmc.

The_Fray

Hi @Qiu

Thanks for the response. Unfortunately, that does not appear to be the issue with my macro, or at least the only issue. Oddly enough, when I click the check mark off and then back on again for the originally working macros replace field, I start getting the same error as my macro...

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335