4 Replies Latest reply: Oct 24, 2012 3:42 AM by Alexander Schediwie RSS

    Find out columns with same value automatically or during import

      Hello,

       

      I have a really old data list which I want to import and it needs to get sorted out, because a lot columns contain the same failue.

      First possibility is to find it out by manual search.

      Maybe it's possible to do this during the process of importing or automatically?

       

      For example:

       

      Header 1Header 2Header 3
      Content1TEXTEXAMPLE125
      Content1Another Example90
      Content1-12
      Content1Text10
      Content1Try4
      Content1Different Text2
      Content1-7
      Content1Header 2 Text8

       

      Like in this example Header 1 contains the same value. So it could be cut out because I know it all contains the same.

       

      I searched the forum and found an article about "Deleting Double Entries" but here it's something different.

       

      Information: The columns I import include text and numbers.

       

      Thanks in advance.

       

      Alex