Sorry this might seem like a silly question but I am not able to figure it out.
I am looking for ways to check if the data received today is similar to the one received yesterday.
To elaborate - we receive several excel files (.csv, .xlsx etc) with 30-40 columns and 1000s of rows. Now although it is understandable that the data received yesterday won’t be exactly the same as that received today, but what I am trying to achieve is just have some sort of checks in place to see if any of the columns are missing than what we would normally expect or if the total number of records has drastically changed as compared to the day before.
Is there any way to do that? If anyone could just guide me on this, that’d be really appreciated.