Alteryx Designer Desktop Discussions

mohit9garg

Hello Alteryx Community,

I'm seeking help to resolve an issue with my batch macro. Here's a brief overview:

- Macro1: Batch File Concate- This macro combines .txt files, even if they have different columns.

- Macro2: Read Files- This macro dynamically selects files based on the date contained in the filename, and then uses Macro1 to read and combine these files.

I've attached a sample workflow where I'm utilizing these macros. Could you please review my macros and the workflow to see how I can improve or fix them?

Thank you for your assistance!

Gaurav_Dhama_

Can you tell what exactly is the problem that needs to be fixed? Is there any error?
Also since there are no input files attached, we cannot recreate the error. Provide few sample files that we can run on?

dreldrel

Hi, I couldn't replicate the error you mentioned. Could you please describe it in more detail?

kyla598ellis

@mohit9garg wrote:
Hello Alteryx Community,

I'm seeking help to resolve an issue with my batch macro. Here's a brief overview:
- Macro1: Batch File Concate- This macro combines .txt files, even if they have different columns.
- Macro2: Read Files- This macro dynamically selects files based on the date contained in the filename, and then uses Macro1 to read and combine these files.

I've attached a sample workflow where I'm utilizing these macros. Could you please review my macros and the workflow to see how I can improve or fix them?

Thank you for your assistance!

Hello,
Your setup sounds solid—Macro1 handles schema variation well, and Macro2 adds dynamic file selection. To improve reliability, ensure Macro1 uses a Union tool with “Auto Config by Name” and that Macro2’s Control Parameter correctly updates the file path. Also, validate that your input template matches expected formats. Sharing your sample workflow on the Alteryx Community forum may help others provide targeted feedback.

Best Regards,
Kyla Ellis

MyAARPMedicare