join sheets with diff schema and join all columns

[hi2019]

HI, 

I cannot figure out the batch macro to join these 3 sheets within these 5 reports that do not have the same schema /columns.

I need to join 5 reports, each report has 6 sheets but I only need 3 of those sheets joined by  unique identifier by control_number, and ALSO I want to join all the columns (does not have all the same columns on each sheet.)

I have attached dummy data 

thanks

[Armon24]

Hi @hi2019 

Try the CReW Wildcard xlsx input macro. Chaosreignswithin.com has the help you need. 

This link can help you get started: https://www.thedataschool.co.uk/laura-peterson/easter-week Hope this helps. 

[koppenhe]

Hi @hi2019 , how about the attached? There's two macros, one to bring in the sheet names (which you can filter on). The second brings in all the data. You can then parse the columns as needed via the break.

[hi2019]

It didnt let me open it due to you have the newer version :/

[PanPP]

What version are you on?

[hi2019]

2020.4.7

[hi2019]

It doesnt apply to excel?

[hi2019]

Is there any other way besides this way? 

[koppenhe]

@hi2019 when you open the packaged workflow I provided you will get an error message stating the workflow was created in a newer version. You should be able to click yes to open the packaged workflow anyway. Does the workflow not open at all for you?