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

    Insert, Update, (no Delete)

    Chris Witman

      https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/LoadData/use-QVD-files-incremental-load.htm

       

      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)

       

      Thanks