Union data from multiple files from a single directory - different header and sheet names

Hi, I'd like to union multiple excel files from a single directory. Only one sheet needs to be combined. However, that one sheet name is different in every file. Also one of the column containing the measure values is different reflecting the month the data is collected in. I am new to Alteryx and would appreciate any guidance.

I have also attached example files.

Aug2020.xlsx

Combined.xlsx

Jul2020.xlsx

Jun2020.xlsx

Transformation

Accepted answers

ImadZidan

Hello @ndani ,

Will this work for you. an idea.

Make sure you replace the path of the datainput tool to your path. Also remember to change the dynamicinput tool template to your file.

Let me know if any issues

Multiplefiles.yxmd

All comments

ImadZidan

Hello @ndani ,

Will this work for you. an idea.

Make sure you replace the path of the datainput tool to your path. Also remember to change the dynamicinput tool template to your file.

Let me know if any issues

Multiplefiles.yxmd

ndani

Hi @ImadZidan ,

Thanks for your response and the solution. This worked great. But in my actual data set the filenames are not necessarily like what I had provided in my sample. Instead are following the pattern below...

XX_YYY_ZZZ_data_202006.xlsx

XX_YYY_ZZZ_data_202007.xlsx

XX_YYY_ZZZ_data_202008.xlsx

Also the corresponding sheet names in these files are 202006, 202007, 202008 for example...

When I applied the flow to the real dataset I get an error. I assume that is because of the filename pattern change. Can we do anything to accommodate these names?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703