1 Reply Latest reply on Nov 22, 2016 6:09 PM by Shinichiro Murakami

    Efficient join strategy

    Brianna J Pak

      I am working on comparing two separate Excel workbooks to see if there are any differences between them. Each workbook has one sheet that lists the title of all of the other sheets within the workbook. Each sheet contains the name and a primary key (so "sheet 3" from excel "workbook A" can easily be compared to "sheet 3" from excel "workbook B"). What would be the most efficient way to create the joins between these entities?