Help with tracking daily change in datasets

[ericren]

Hi All, hope you're all doing well. This is my first post in the Alteryx forum. Please see the case below and possibly suggest a solution in alteryx.

• File 1 has 3 sheets
  • Difference, Current and Previous
• File 2 has 1 sheet
  • Current

Goal:

• Replace Previous sheet with File 1's Current but retain the sheet name "Previous"
• Replace Current sheet with File 2's Current sheet.
• Replace Difference sheet with any rows that are new.
• For File 1, keep the same sheet names 
• Difference, Current and Previous
• Difference, Current and Previous

[JarekSkudrzyk · Accepted solution]

@ericren could you please be more specific regarding the goals? Could you maybe provide some example data on both input and desired output?
thanks in advance