6 Replies Latest reply: Aug 3, 2017 9:37 AM by Chris Witman RSS

    Insert, Update, (no Delete)

    Chris Witman



      I am looking to do insert and update within ticket # data.


      So my data is a weekly csv that gets automatically sent to a directory.


      The unique key is ticket # the other fields that change are closed date and comment section.


      So i want the data load to update these fields if necessary when there is a new file dropped each week.

      instead of creating a duplicate when these fields have data.


      Is this possible when using CSV?

      (I know i can just archive or delete old CSVs, but I would like this to work without having to do that)