Duplicate Entries Count

[Karthick30]

Hi,

I have a table like below

I need to find how many times, Numbers are getting duplicated. In this example , 410 coming 2 times , 300 coming 2 times and 209 coming 2 times.

So I need to Show Duplicates Entries as 3 which is 410,200,209

Any way to achieve this

[sidhiq91]

Please use below:

NoConcatenate
Temp:
Load * Inline [
ID,Number
SxS04, 410
kxm41,309
scu02, 105
SxS04, 410
bxm42,300
bxm42,300
skf41, 209
rxm49, 209
];

NoConcatenate
Temp1:
Load *,
if(Number=Peek(Number),'Match','No match') as Check
Resident Temp
Order by Number desc;

NoConcatenate
Temp2:
Load *
Resident Temp1
Where match(Check,'Match');

Drop table Temp,Temp1;

Exit Script;