1 Reply Latest reply: May 15, 2014 10:10 AM by fatboy02 _ RSS

    Select rows according to their uniqueness

    fatboy02 _

      I'm trying to use the "select rows according to their uniqueness" option to filter out duplicate rows of data but I seem to be missing something. 

       

      My process is Filter, advanced, select rows according to their uniqueness, and unique rows with the key of 'assignment', which is column 6 of the data below.  That column is a PO number combined with the corresponding line item number that has problems I need to address.  I only want one instance of each PO & line item. 

       

      In this case the full data is 1997 rows and when I filter the duplicates it returns 602 rows.  However, I notice that several rows are missing.  I exported to Excel without a filter and then filtered the duplicates in Excel and it returns 739 rows.

       

      Any suggestions on what I might be missing?

       

       

      0030     210500     1053510015     9/13/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     175

      0030     210500     1053510015     9/16/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     172

      0030     210500     1053510015     9/15/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     173

      0030     210500     1053510015     9/13/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     175

      0030     210500     1053510015     9/16/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     172

      0030     210500     1053510015     9/18/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     170

      0030     210500     1053510015     9/15/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     173

      0030     210500     1053510015     9/19/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     169

      0030     210500     1053510015     9/20/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     168

      0030     210500     1053510015     9/21/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     167

      0030     210500     1053510015     9/21/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     167

      0030     210500     1053510015     9/21/2010     4507742656     450774265600001     1     101357964     Sand-CRC Premium     9/7/2010     1177318     SPECIALTY CHEMICALS INC     H19     HB25915     167

      /code