Use wild card union ,and distinguish by Path or sheet name.
Save two excel file under same folder and wild card union,
And put fields on Row and "Sheet" on column.
To union tables using wildcard search
- On the data source page, double-click New Union to set up the union.
- Click Wildcard (automatic) in the Union dialog box.
- Enter the search criteria that you want Tableau to use to find tables to include in the union.For example, you can enter *2016 in the Include text box to union tables in Excel worksheets that end with "2016" in their names. Search criteria like this will result in the union of May2016, June2016, and July2016 tables (Excel worksheets), from the selected connection. In this case, the connection is called Sales, and the connection made to the Excel workbook containing the worksheets you wanted was in the quarter_3 folder in the sales directory (e.g., Z:\sales\quarter_3).
- Click Apply or OK to union.
Have you seen the guidance on comparing excel sheets from within excel ? https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/ - start from the section titled 'How to compare two excel sheets for differences in values'
I'd approach this in a similar way using Tableau, but each week you would have to data > edit relationships with the new dataset to compare it with the (new) old dataset, so I think it might be a bit faster if you do it in excel.
Thanks! However, my entire upload process is built using Tableau for our Travel and Expense systems, both based off of one sheet from our HR system. I was hoping for a calculation to compare Email, Subsidiary, and Manager emails across the same Employee ID in two sheets.
Like IF the Employee ID matches, but Email, Subsidiary, or Manager email does not match, then "changed" or something of that nature. I'm just not familiar enough with calculations/syntax to figure this out...