Crosscheck Payroll data

[curious1414]

My colleague and I are trying to build a base where we can compare the payroll data from a csv. file (outsourced data) with data we have already stored in Airtable. We would like to compare the expected payrate we have stored in Airtable to the actual pay in the payroll report csv. file. 

We are having a difficult time figured out a way to compare two tables within the same base. We are importing a new csv. file into a table every 2 weeks and then we have a second table where our stationary data from Airtable lives and we hope to cross check both of these tables to make sure everyone is receiving the correct anticipated pay and if that is anticipated pay is not aligned with the expected pay then creating formula that would indicate to us that the amounts do not match. 

We were wondering if there is anyone out there who has any advice for comparing two sets that are on two separate tables but within the same base and creating a way to indicate to us the mismatches? We thought about creating a more in-depth deduping process but we are not sure if that is possible to dedupe using two separate tables of data. 

Any help or advice is welcome!

[TheTimeSavingCo]

Hmm, is there an unique identifier between the stationary table and each CSV file?  An employee ID perhaps?  If so, you could use that to link the data together, use a lookup field to pull the CSV data into the stationary table, and then use a formula field to compare the two against each other

If this is possible, I'd recommend using the CSV Import extension, and the workflow would be:
1. Import via CSV Import extension, put the employee ID into the linked field to the stationary table
2. Go to the stationary table and check that everything's fine
3. Go to the table where the CSV data is located and delete all the records so that it's ready for the next fortnight's import