Importing multiple excel files with multiple sheets having different scheme all at once.

Govind_Dileep_G

Hi, 

I have around 30 excel files with each of them having 4 sheets. I want to make a batch macro to pull all the files at once. The schema is also different for different pages. I tried to do it by referring to many posts but i am not able to reach the desired output. can anyone share any insights or knowledge regarding this?. Since i am new to Alteryx i am finding difficulties here.

Thanks in advance. 

Jean-Balteryx

Hi @Govind_Dileep_G ,

This article will guide you through the process of importing multiple sheets from multiple excel files : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220#MultipleSheets