We are getting daily Feed files in CSV format and they get loaded into SharePoitn 2013 Document Library.
We are planning to create a Workflow on Doc Libraty so that the data can be inserted and udpated (if the same data already available in the list).
Ex: Employee Id, First Name, Middle Name, Last Name, Status (Active/InActive) - Data comes in CSV.
How can we Update the Data in the list if the same Employee record (by Employee Id) got changed today because of the CSV feed ?
https://www.youtube.com/watch?v=GBU4p0gRdOU - Video shows how can we insert new records all the time but it won't talk about how to update the exisiting record.
Instead of creating an item (Video: 5:57), check if an entry in your people list with the employee id already exists. (For example using query list - Employee Id matches - count returned elements)
If the entry exists, update it, if not, create it.