Import two files with multiple sheets but different fields

Hi all!

I am trying to input two files with multiple sheets. The files are the same but one of them has updated information populated, I'm creating a workflow to spot differences between files and do some checks. The files type is .xlsm

Sheet 1 from File 1 has the same fields as sheet 1 from file 2, but fields from sheet 2 are different than sheet 1 and so on.

The result should be a table with all the information from both files with fields that specify which field and sheet the information belongs to. I can manage to then separate the information with filters and transpose it.

I saw some posts with macros but I am not really good with them. I tried to modify the file paths so they can work on my computer but I couldn't. In case the solution is a macro, could you please explain me how to save it and modify the settings so I can save it on my computer and share with others?

It would be incredible if we can also build it as an application so I can select both files even if they are saved in different folders, but that's not important.

Thank you in advance!!

Input

Apps

Batch Macro

Accepted answers

OTrieger

You can read more about it here with some attached WFs https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Importing-an-Excel-file-with-Multiple-Sheets/td-p/1028609

All comments

OTrieger

@Igomez17
There are several options here, however the solution is the same. Getting the files imported with List of Sheet Names Then replace that part in the Full path with the actual sheet names and get a batch macro to get all the data based on the new full path.

Now you can do it by 2 Browse Tools to select each of the files or with a Directory tool that will indicate a folder where the 2 files will be stored and then you will need actually 2 batch macros one to call in the list of sheet names and then one to open the files

OTrieger

You can read more about it here with some attached WFs https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Importing-an-Excel-file-with-Multiple-Sheets/td-p/1028609

OTrieger

I myself do not share WFs, there are very good lessons on Alteryx Academy where you can learn the knowledge how to do it. Knowledge = Power. So it is worth spending your time learning it as macros are a very powerful tools that will enable you many advanced solutions. So if you are really planning to use Alteryx do it the right way, which is learning it so you will know what to do.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703