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