Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danilopvh
New Contributor II

Which columns repeat the same plate

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.

Community Browser