Import data from multiple sheets in an excel with different schema

[SaiJanani]

Hello

I am trying to import data from multiple sheets from a single excel file and want to combine them to a single file. Some of these tabs has different schema. Please help! Thanks

[JosephSerpis]

Hi @SaiJanani check out this link it should help.

[Sebastiaandb · Accepted solution]

Hi @SaiJanani ,

Here you go:

Change the filepath in the browse input tool in both the workflow and the macro and youll be fine :-). In case your first sheet is called different than "sheet1", change the action tool reference in the macro as well.

Greetings,

Seb

[atcodedog05]

Hi @SaiJanani 

Edit : @Sebastiaandb solution for a single should work. You can follow this post for more understanding https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t... 

Use this guide to downgrade the packaged workflow to lower https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/... 

Hope this helps : )

[SaiJanani]

Thank you all for your response.

@Sebastiaandb Thank you for your input. But it reads only one sheet for which the name is mentioned in the action tool. I am trying to read data from all tabs in a excel with each tab having different schema. Anything I am missing out or to be included?

[basty0209]

Hi SaiJanni,

Where you able to finally resolve your issue? How did you able to read the data from all the tabs?  Appreciate your advise.

Thanks a lot.