Microsoft Dynamics AX (Archived)

Count duplicate value in table

(0) Share

Report

Posted on by Ismail Mohamed

570

Hello..

can anyone help in count duplicate value group by InventLocationId ?

The original table like that

Here every inventlocationId has one salesId but when I Wrote next code

    insert_recordset EGCSOCountTMP02 (InventLocationId,CountRec)
    select InventLocationId,count(RecId) from EGCSOCountTMP01
    group by InventLocationId;

the previous count gave me for Ex. U-Sw-Nahia-15 = 4 even it the same salesId

what i result need is U-Sw-Nahia-1 = 1 salesId

Thanks

*This post is locked for comments

All responses (2)

Answers (0)

AhmedMgamal 75 on at

Like (0)

Report

RE: Count duplicate value in table

can you please clarify what you want to do, we can't help you as we don't understand what you want to achieve,please provide us with sample of data and expected result and then we can help you to build up the query.
Ismail Mohamed 570 on at

Like (0)

Report
RE: Count duplicate value in table

I also tried to get count from the sales table but same result

insert_recordset EGCSOCountTMP02 (InventLocationId,Countrec) select InventLocationId from EGCSOCountTMP01 group by InventLocationId join count(RecId) from salesTable where salesTable.SalesId == EGCSOCountTMP01.SalesId;