Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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