I have an index set up and functioning properly on initial ingest. What I'd like to accomplish is the "upsert" of events on future files.
Example
File 1 (childCount_08-13-2013.txt)
Date, Name, # of Kids
08/13/2013, Nicky Blank, 4
08/13/2013, Mike Dorn, 2
08/13/2013, Les Paul, 1
File 2 (childCount_08-23-2013.txt)
Date, Name, # of Kids
08/23/2013, Nicky Blank, 6
08/23/2013, Phillip Jacks, 3
08/23/2013, Tina Walls, 1
DESIRED OUTPUT (Contains all unique entries and updates any existing entries)
08/23/2013, Nicky Blank, 6
08/13/2013, Mike Dorn, 2
08/13/2013, Les Paul, 1
08/23/2013, Phillip Jacks, 3
08/23/2013, Tina Walls, 1
Any assistance would be greatly appreciated.
... View more