Appending tabs from update excel file to the master excel file

[schuprov]

Hello all,

I am trying to create a workflow that automatically reads in an update file we get daily from the vendor and then appends that data onto the master file that we use for reconciliation purposes. Tabs and schema are the same across the two files. The issue I am running into is that both the master file and the update file are over 500K rows in excel. Is there a way to make Alteryx only read in business date minus one from the update file and copy and paste that information only into the master file? For example, if the master file has the sales data for an entire month, Alteryx will then only take the missing dates from the update file and copy those over to the master file.

Thank you

[Felipe_Ribeir0]

Hi @schuprov 

With this quantity of rows, you should consider to use a database.

But i think this will work for you, please let me know if it do not.

1)get max date from the master file

2)compare max date from master file with the daily file, filtering just new dates

3)append the new dates data to the master file