How to match repeated values

[sculptorlv]

Hello again. I really hope for your help!

I have such table:

Nr. Descripiont. Value

001     AA               hotel

002     BB               motel

003     CC               mobile

003     CC               cinema

005     DD               cinema

006     EE               mobile

So, there are possible several values for the last column, and the values are no unique.

I need somhow in qlickview chart to point out Nr. (numbers) wich contain NOT unique values. For my example:

003 CC          mobile

003 CC          cinema

005 DD          cinema

006 EE             mobile

Thank you in advance!

[sushil353 · Accepted solution]

Hi,

using script below you can flag all the duplicate items:

Temp:

LOAD *,if(flag >1,1,0) as Flag;

load

*,AutoNumber(f1,f2) as flag Inline

[

number,f1,f2

001,AA,hotel

002,BB,motel

003,CC,mobile

003,CC,cinema

005,DD,cinema

006,EE,mobile

];

Left Join

LOAD f2,1 as duplicateflag

Resident Temp

where Flag =1;

DROP Field flag,Flag;

HTH

Sushil