Combine multiple tabs with different schema from multiple excel files

Question

Hi team,

I have 30 excel files. Each excel file can have different number of tabs i.e one excel can have 1 tab and second excel can have 5 tabs. The data is all these tabs might have different format and sturcture.

Is it possible to combine all the tabs in these 30 files into one file with multiple tabs.

If there are 80 tabs combined in all these excel files - I want a output file with 80 different tabs.

Please help.

atcodedog05 · Answer

Hi @Praneeth1996

Try this guide to downgrade version https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps : )

Qiu · Answer

@Praneeth1996 
Your alteryx is of old version... 🙄

Praneeth1996 · Answer

@Qiu

I am getting the below error when I try to open the provided zip file.

Failure to Import \Desktop\Multi Sheet Import Example 2.yxzp.There was an error opening "\Desktop\Multi Sheet Import Example 2\Multi Sheet Import Example 2.yxmd":

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using