Import Excel file with multiple sheets and with different schema

Hi,

I faced an issue when I tried to import data from an Import Excel file with multiple sheets and with different schema. Please see attached an example with dummy data how the input can look like.

I tried to find a solution everywhere, but did not succeed. Probably if anything can help, that is probably a batch macro, but was not able to figure out, how.

I would like to see in the end, that all the data with the same column names should be placed under eachother, but if there is something which is unique, for the other sheets just write Null(), after that I can do the necessary steps which are needed for me.

Can anyone help me with this one? I would really appretiate.

Thanks in advance!

input.xlsx

Input

Batch Macro

Accepted answers

abacon

@vkirkov98 Here is a pre-built macro you can use to extract all the data into one data stream - Dynamic XLSX Input Tool.

Yes, a batch macro is the way to go.

Bacon

All comments

abacon

@vkirkov98 Here is a pre-built macro you can use to extract all the data into one data stream - Dynamic XLSX Input Tool.

Yes, a batch macro is the way to go.

Bacon

dreldrel

Agreed with @abacon, Batch Macro is the best go-for. You can set up the way you'd like to combine the columns in the interface tool settings. Thanks @abacon for sharing the lovely toolset I believe a lot of people have faced this similar issue

ChrisTX

Check out this knowledge base article:

The Ultimate Input Data Flowchart

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

vkirkov98

Thank you @abacon , I tried this method and well, I need to change inside the macro the input to mine to function well. Also saw a filter out option in the message chain which is helpful for me too. In the beginning it did not work when inside the macros the test file was written, but after changing to my real input it worked. In the future is I will have issues will come back, but for now I consider it as solved!
Also thanks for everyone who added anything to this topic!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280