Alteryx - batch input file

Question

Dear Community,

I hope this email finds you well. I am currently working on a workflow that involves checking Questionnaires. The workflow checks whether three tabs within the document meet the input requirements, such as fulfilling mandatory fields. The output of the workflow generates three tabs to perform this checking.

However, I am now seeking a solution for batch input, where all received Questionnaires, such as "QuestionnaireA_FromAAA" and "QuestionnaireA_FromBBB," can be processed together. Specifically, I would like the workflow to input all documents within the "QuestionnaireA" folder and output the checking files into "Checking_AAA" and "Checking_BBB" folders, respectively.

I would appreciate your guidance on how to achieve this batch input functionality. Should I create a macro? If so, could you please provide detailed steps on how to proceed?

Thank you in advance for your assistance.

Best regards,
K

Workflow for checking.yxmd

yychim · Answer

@Qiu Hi Polar, i can't understand that workflow.. Sorry, do u have any steps to show me how can i leverage the workflow in ur link to put it in my workflow?

yychim · Answer

Hi  @binu_acs here u go. Thanks a lot!

Qiu · Answer

@yychim 
Check this Macro by @mceleavey , it will be able to bring in your data with the File Name and Sheet (tab) name.
For the output part, we can actually specify the Full Path then output to aovid many similar tool Groups to output each Tab.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Input-multiple-Excel-files-with-multiple-sheets-with-same-layout/td-p/769498