i’m reading several posts on the subject, but i can’t get what i need.
I have to compare two excel tables, which have a variable number of rows day by day.
So I have to create a table containing the mismatches.
The files are extracted from a cloud.
Files can grow day by day,
or they can simply be changed.
I need to backup if the file is new or if one of the old has been changed.
I have created two files.
One with the new scraping and one with the old scraping from the previous day.
How can I find the lines that are different?
|_Enterprise_CJ_Automation Layer_Private||Sales Enterprise||23/07/2020 18:11|
|Acquisto apparato - COM||Variazione Post||21/07/2020 10:07|
|Agevolazione Fiscale (IVA) - COM||Variazione Post||15/01/2020 17:38|
|Agevolazioni fiscali Ausili Informatici - COM||Variazione Post||28/01/2020 09:05|
|Aggancio MOP||Deviazioni Pre||24/02/2020 13:08|
The file contains 3 columns.
In the last “Changed” there is the date of the last modification of the file,
which I have to compare with the previous file.
The number of documents varies, so the sorting may differ from day to day.
Can help me… please?