Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiple Excel Sheets

NiranjanK1
8 - Asteroid

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

25 REPLIES 25
NiranjanK1
8 - Asteroid

Any suggestions please 

caltang
17 - Castor
17 - Castor

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.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
NiranjanK1
8 - Asteroid

@caltang thank you so much for detailed explanation.

Any best example workflow you give me.

caltang
17 - Castor
17 - Castor

Can you provide some data?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
NiranjanK1
8 - Asteroid

@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
8 - Asteroid

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

caltang
17 - Castor
17 - Castor

Please find attached. Hope this helps!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
NiranjanK1
8 - Asteroid

@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
17 - Castor
17 - Castor

Here you go! Made it more dynamic. @NiranjanK1 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels