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.