Combining multiple identical formatted files

Question

Hi All,

I attempted to create a workflow to combine three different sets of data(see attached excel workbooks that are entered into a standard template using the step by step explanation provided on the site but I couldn't get it to work. See attached excel workbooks.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

Essentially I need to have this setup so if I have 2 or 12 files I can combine them into one and then manipulate the data from there to sum the data in Sheet 3 by Employee Name for Columns C and L which will then be applied against another workflow and joined to the output date there.

I get errors like the schema in the 2nd file does not match the first or to select a sheet when I have selected a sheet.

Any help would be appreciated.

Dummy Data 3.xlsx

Dummy Data 2.xlsx

Dummy Data 1.xlsx

mabdulh1 · Answer

I need to share this workflow so I need a workaround for these macros. Is there any?

Would me creating this in my version work manually instead of copying it over?

Both solutions work but I am not able to update to the new version as the company has not cleared the new version to be installed yet.

Qiu · Answer

@mabdulh1 
Company policy sometimes can really be an obstacle.

Anyway, would be possible to install latest Alteryx on you personal PC and start a triial?

mabdulh1 · Answer

HI @mceleavey and @Qiu,

I was trying both methods but I am having an issue with updating my version to the most current version. I am working on getting it resolved but in the meantime I have been having issues either opening the workflows or if it does open the macros running with errors.

I believe might be due to some funcitonality issues running it with an older software but im not sure. I for some reason still have 2019.3 on my computer.

Any suggestions to continue to work until I am able to get my software updated.