Processing multiple files with same logic

[Lakshmikanth_2021]

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. 

[Swathi]

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

[messi007]

@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-Exce...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/load-multiple-excel-files-from...

Best,

[Qiu]

@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...