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

[Lorenakocheran]

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 

[OTrieger]

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 <List of Sheet Names>
Then with a Formula tool replace <List of Sheet Names> 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

[peterr_h]

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

[Lorenakocheran]

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