2 Replies Latest reply: Jun 20, 2017 6:02 PM by Wallo Atkinson RSS

    Duplicates in other fields after subfield-ing

    Joanne Leung

      I have the following columns:

       

      Customer NameLevelProduct Purchased
      ABCAEggs
      ABCABacon
      DEFCCheese
      GHIAPerfume
      GHIABody Spray

       

       

      Initially I had the string values for 'Product Purchased'  (e.g. 'Eggs,Bacon' for Customer 'ABC') so I used the subfield function during my load, this gave me duplicates in 'Level' and 'Customer Name'.

      I want to perform some analysis like the count of levels by Customer Name, but it counts 'A' as 4 as there are four records of 'A' instead of '2'.

       

      what is the best way to do this?