Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Input multiple xlsx files and union them

Highlighted
Alteryx Certified Partner

I always get the error no sheet specified. You must specify a sheet. I thought it would read all of them. Any help is highly appreciated!!!

Highlighted
Alteryx Certified Partner

Hi,

 

I applied the same method but there was success when one excel file contained one sheet only. But if we have many sheets in one excel file then this gave errors.

 

Can you please help in this?

 

Thanks in advance!

Highlighted
7 - Meteor

I encountered the same error. For all these records(#4, #26, #27) in the Directory tool, I had 1 sheet hidden in each Excel file.

alteryx multiple files Macro error.PNG

Highlighted
7 - Meteor

Hi,

 

I believe you are supposed to specify the Sheet that you wish for Alteryx to read if you have more than one sheets in excel as Alteryx is unable to tell which sheet you are trying to read in.

Highlighted
7 - Meteor

@jcyc , @Claje , 

Are there any settings to be done in the Macro. 

I am looking to union multiple excel files with the help of a directory tool. 

Please find the settings I have applied below and advise regarding any changes that should be made. 

 

 

I have the excel sheets in one folder. And only 1 sheet per excel. 

 

Thanks a ton in advance

Annamalai

Labels