Hi, I have a sample CSV called original.csv . Each day, a search is ran and saved to new.csv . What search to do I need to add an entry to original.csv only when there's a change in new.csv ? It's sorted by the field data_center .
Original.csv looks like:
data_center desktop_amount server_amount employee_amount date
alpha 25 10 20 08/29/2019
bravo 10 5 8 08/29/2019
charlie 5 2 3 08/29/2019
When the new daily search is ran and results are exported to new.csv , it looks like this:
data_center desktop_amount server_amount employee_amount date
alpha 22 10 20 08/30/2019
bravo 10 7 10 08/30/2019
charlie 5 2 3 08/30/2019
What search do I need to create this new table based off the changes in new.csv for each data_center ?:
data_center desktop_amount server_amount employee_amount date
alpha 25 10 20 08/29/2019
alpha 22 10 20 08/30/2019
bravo 10 5 8 08/29/2019
bravo 10 7 10 08/30/2019
charlie 5 2 3 08/30/2019
Since there were changes in data_centers alpha and bravo (alpha's desktop_amount decreased by 3 and bravo's server_amount and employee_amount increased by 2), those new entries were added to original.csv . Since charlie had no change, do noting with it.
... View more