Hi,
Does anyone have a standard Macro where Alteryx will read one sheet (same format in all excel files) from excel files with different schema? And then produce one output with all the sheet information underneath one another?
New to alteryx so any advice will be helpful
Solved! Go to Solution.
Hi @SlStephanieLouw,
please Check this macro:
https://gallery.alteryx.com/#!app/Read_All_Excel_Files/58dd51b3a18e9e18fca64172
i think this is the Best macro to read many files at the same time.
it will also work for files with difrent schemas.
Hi @Emil_Kos
Is there a simpler version?
I am looking at only xlxs workbooks (for some reason they have different schemas).
And I only need one sheet from each workbook.
I have created a macro that reads all the workbooks regardless of schema. But when I add the macro to my directory tool then the error 'No sheet specified' occurs.
Now I need to create full path that includes file path and sheet name - which I am struggling to incorporate properly in my workflow.
Any basic solution for this?
Which will be helpful for you and give an idea.
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
Guessing you have missed the step of adding sheetname to filename.
Hope this helps : )