Workflow that get all the sheet name in the Multiple file

[arjundelara]

Hi All,

I'm moving forward of my workflow to create a batch macro that gather all the sheet name in the multiple file and have no error message for a different schema output.

Thank you!

[Qiu · Accepted solution]

@arjundelara 
I always keep these 3 as my special tools.

Hope they help.

[arjundelara]

Hi @Qiu ,

Highly Appreciated. Will review on how it works !

Thank you so much.

Regards,

[atcodedog05]

Hi @arjundelara 

You can refer this post too its really helpful.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Hope this helps 🙂

[arjundelara]

Hi @atcodedog05 ,

Thanks! It'll helpful.

Cheers,

[JokeFun]

The multi-sheet names macro failed for xls files. Do you have any solution on that?

[apathetichell]

Do you mean .xls (as in old Excel?) if so every reference to a .xlsx file and every references to fileformat 25 would have be changed. .xls is fileformat 8 in Alteryx. Different filetypes. You'd need to run all the macros with a sample .xls file and clear it of any .xlsx values.