Import Excel file with multiple sheets and with different schema

[vkirkov98]

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!

[abacon · Accepted solution]

@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!