Dynamic Input with excel data that does not have uniform headers

Question

I have a file of sales tax rates that was imported into excel via a pdf. Each page was inserted into a different worksheet and does not have uniform headers. I attempted to consolidate this information in Alterxy with an input (sheet names) and a dynamic input but the output only took the data from the first worksheet. Recommendations?

Sales Tax Rates.xlsx

binu_acs · Answer

@ACES2019 Another way of doing this

CombineSheets_240523.yxzp

npariso · Answer

Hi ACES2019,

The columns on each sheet are referred to as a schema, because these sheets have different columns then we need a solution which is capable of handling multiple schemas and the primary method of doing this is by using a batch macro. See the attached workflow which takes your file and imports all of the data without consideration of column names.

This uses the Import Multiple Schema Flat Files macro from the solution referenced in this post: SOLVED Import multiple tabs with different schema as a separate input file, edit & combine later

Please note that because of the amount of sheets to be imported, the workflow takes about one minute to run.

Please let me know if you have any questions! More than happy to help.

Multiple Schemas Import.yxzp