Multiple Excel Sheets

[NiranjanK1]

Hi All,

I have an excel file with multiple sheet names. I want to read all excel sheets information. I have tried with community examples it is working on my desktop. when i move same workflow to shared folder. it is not working. I have tried with multiple ways examples avilable in community. Please suggest any other way can i read all sheets details.

Thanks in Advance,

Niranjan

[NiranjanK1]

Any suggestions please 

[caltang]

If your sheets are of the same data format (meaning, the fields - i.e the columns are of the same name, same data type, and of the same length), then you can use a Dynamic Input tool to call all of it in.

Otherwise, you can also use a Batch Macro to do the job.

Refer to documentation below:

1. https://help.alteryx.com/20231/designer/batch-macro#:~:text=A%20Batch%20macro%20runs%20multiple,to%2.... 
2. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-Macro-Input-Multiple-She...
3. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-To-Import-Multiple-Exce...

If you're still stuck, you can provide us with some sample data and we can show you also.

[NiranjanK1]

@caltang thank you so much for detailed explanation.

Any best example workflow you give me.

[caltang]

Can you provide some data?

[NiranjanK1]

@caltang I do not have access upload/send an emails. I'm doing it from my mobile. Tomorrow I can upload sample data with personal laptop.

[NiranjanK1]

@caltang Please find the attached sample data, Im unable to read multiple sheets details. Please help me.

[caltang · Accepted solution]

Please find attached. Hope this helps!

[NiranjanK1]

@caltang I could see sheet1 data 4 times. i want to fetch multiple sheets data. Please suggest me do i need to select any other option. 

[caltang · Accepted solution]

Here you go! Made it more dynamic. @NiranjanK1