23 Replies Latest reply: Jun 19, 2014 5:59 AM by Rachel Boey RSS

    reasons for duplicate rows

      Hi, why are there duplicate rows? I concatenated tables from different sources and 'itemnum' is primary key. The itemnum appears in all the tables and has data for all columns but still duplicates, for example, it has data for all the columns from one table but is null for the other columns in other tables. So there is duplicate like below:

       

      itemnumsitenamebalanceclasscodeGroup
      1009AD-B--
      1009--45-FGH

       

      How can I combine everything to one row (distinct itemnum)?

       

      itemnumsitenamebalanceclasscodeGroup
      1009AD45BFGH

       

      Thanks.