2 excels files 10 sheets (tabs) join to find duplicates

Question

Hi... I have 2 files with 10 sheets each (same format) that now I am doing a v-lookup one by one sheet to sheet (10 times) everyday :(

I am thinking to use a join in Alteryx, but how can I do it in 10 sheets? and how can I do it to help me and do not have to do it sheet by sheet each time each day?

I see information in how to bring multiple sheets to the canvas but how can I do a join in those sheets? what I need to find is the duplicates and the new information of each sheet.

Thanks

Lorenakocheran · Answer

That will be very useful and extra help is always good.

I am attaching dummy info to work.

From those 2 files I need to find what are the new loans Numbers (The numbers on this files are fake) and so all the infor on it but the column names

Test-2.xlsx

Test-1.xlsx

peterr_h · Answer

Hi @Lorenakocheran ,

If the previous response isn't enough detail (though this is the method I would suggest using too), then please provide data (or dummy data) that fits the format that you want, and a desired output/function, and this will be easier to create.

Cheers,

Peter

OTrieger · Answer

Hello @Lorenakocheran You will need here the use of batch macro/s. Set a Directory tool, then connect it to 1st batch macro where it will call the files with the selected option Then with a Formula tool replace with The sheets name. Connect it to another batch macro that you open all the full path, meaning each one of the different sheets. At the output of the batch macro you will have all the data from all files and all sheets