Combining Files with Different Schemas in Excel with Multiple Worksheets

[Steph23]

Hi there! I'm trying to combine 10+ files currently saved in a shared folder. Unfortunately, the schema changes across the files (new fields are added or removed month after month). Each file in the folder contain 2 worksheets (1) Vacancy (2) Pivot. I'm trying to combine all the files to create a master list. I came across this YouTube clip where #3 helped in my case where there was only 1 worksheet in the file (I tested one), but results in an error when there are multiple sheets that reads "Record #: Tool #: No sheet specified, you must specify a sheet." (https://youtu.be/MjGxzsMJINQ) I tried adding a comment, but it's an old clip and doesn't seem to be getting responses. Would anyone know how to distinguish the sheet to pull in using this solution? Thanks!!

[Qiu]

@Steph23 
I think you are looking this macro.

[atcodedog05 · Accepted solution]

Hi @Steph23 

You can give this workflow also a try. Just insert the path here.

Hope this helps : )

[Steph23]

Hi @Qiu . I'm unable to open your attachment... 

I'm using version 2018.4.4 if that helps at all...

[Steph23]

@atcodedog05 I'm getting the same error for your attachment that I am for @Qiu 's... 😞

[Qiu]

@Steph23 

Would it be possible for you to upgrade your alteryx version?
It is much out-of-date already.

[Steph23]

@Qiu unfortunately not... I'm using the version my company has issued to my computer... 😞

[Qiu]

@atcodedog05 
You are up! 😁
Share your magic to downgrade the flow

[atcodedog05]

Hi @Steph23 

Here is a guide on how to downgrade packaged workflows 🙂.

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

Thank you for the callout @Qiu 😀

Hope this helps : )

[Steph23]

@Qiu & @atcodedog05  - Thank you both so much for this information! Unfortunately, my laptop is locked down so much that I can't access the "Analytic Apps/Macros/Workflows" folder... However, I did just receive notice that our company is upgrading to the 2021 version next week, so I'll hop back in here after that happens to try again!