Processing multiple files with same logic

Question

I have 47 excel files to take as input and paste some content to a new sheet in all 47 files.

How can I input all 47 files and repeat the same process for all files.

Qiu · Answer

@Lakshmikanth_2021 
Basically the same idea as below. 😂 but customized for your case.

Read the Full File Name and Sheet Name with Wild card then use a Batch Macro to process the data as your desire.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/load-multiple-excel-files-from-a-folder/td-p/221484

0123-Lakshmikanth_2021.yxzp

messi007 · Answer

@Lakshmikanth_2021,

Please take a look on the links below :

https://knowledge.alteryx.com/index/s/article/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range-into-a-Workflow-1583461464206

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/load-multiple-excel-files-from-a-folder/td-p/221484

Best,

Swathi · Answer

Is the content file only one or 47 different files again?