1 Reply Latest reply on Feb 19, 2013 1:55 PM by philmodjunk

    preventing duplicates when importing from a CSV

    ConnieColbert

      Title

      preventing duplicates when importing from a CSV

      Post

           How does one write the calculation:

           If last name and first name appear twice, return a value of "2" to the  "Duplicate" field.

        • 1. Re: preventing duplicates when importing from a CSV
          philmodjunk

               It's actually easier to filter out duplicates all together than to allow the record to import and then flag the duplicate...

               I haven't tried this during an import, but if you define a self join on the target table matching by first and last name fields, the duplicate table can be defined to auto-enter:

               Count ( TargetTable 2::firstName )

               This requires enabling auto-enter options during import. There's a check box for that in a small dialog that appers just before the import starts.