Union similar sheets of different workbooks

[RajatRehria]

Dear Community,

I hope you all doing well. Kindly help me solving a query.

I have two Different workbooks (Sample_1 and Sample_2) with multiple sheets in each workbook, however I want a sheet (named "One") which is available in both the workbooks and are very similar but i am not finding a way to bring both workbooks via Directory tool and Union those similar sheets (i.e. "One") which I want to combine.

I have prepared two macros for the same however one of macro which Union both the similar sheets is not working, Kindly help. Many thanks.

[binuacs · Accepted solution]

@RajatRehria You need to update your macro. Attaching the sample workflow 

[RajatRehria]

Hi Binuacs, can u please share this workflow in Alteryx Version: 2020.4.5.12471 as while opening i am getting an error (refer attached) and it not opening.

[binuacs · Accepted solution]

@RajatRehria attaching the workflow and the macros

[RajatRehria]

Many thanks for the solution