Import Different Excel file format and Subfolder in Alteryx

Question

Hi Community,

May i know how to import different excel format which coming from different subfolder into the Alteryx ?

Any Macro recommended which can be used under Alteryx version 2019.13?

As I not familiar with the Macro, can someone please guide me on how should i modify marco and locate my folders if you are sharing the macro ?

Many thanks for your helps

SH_94 · Answer

Hi @ pedrodrfaria,

May i know if the marco work for xlsb format as well?

pedrodrfaria · Answer

I attached one for CSV

To change the macro, open the macro and replace the file used inside of the macro with one for different types of extensions and then save these different versions of the macro

CSV Opener.yxmc

SH_94 · Answer

Hi@ pedrodrfaria,

I encounter the error as shown in the screenshot below ? Could you please advise me how should i proceed to clear the error?