0 Replies Latest reply: May 7, 2018 6:33 PM by DANILO COSTA MANUSSAKIS RSS

    Which columns repeat the same plate

    DANILO COSTA MANUSSAKIS

      Hi .. I need to find a way to identify which PLACES are repeated in each SEQ_ITEM_GUIA among the 7 columns. I inform you that this table has 2.5 million lines.

       

      SEQ_ITEM_GUIA

      Placa_1

      Placa2

      Placa_3

      Placa_4

      Placa_5

      Placa_6

      Placa_7

      59016084

      NEA4541

      -

      NEA4400

      -

      NEA4444

      NEF0478

      -

      59016085

      NEA4456

      -

      NEA4541

      NEA4456

      -

      NEF0477

      NEF0455

      59016086

      NEA4400

      NEF0477

      -

      NEA4400

      -

      NEF0463

      -

      59016087

      NEA4444

      -

      NEA4444

      NEA4444

      -

      NEF0455

      -

       

       

      Thanks

       

      Note. I'm Brazilian, my writing is not good. But my reading is very good.