This content has been marked as final. Show 2 replies
I've created a daily incremental extract but I need to validate and track some occurrence IDs.
So my data is in this format:
I'd like to be able to calculate 3 things:
So a table that looks like this:
|Date||Total No of Occurances||Pre-Existing Occurances||New Occurances|
And another table that looks like:
I would then be able to work out the last one from the second table above.