Count Duplicate values

[#1]

Hi,

I need output as following as data with me is ID, FID, please help

ID	FID	Output
1	10	3 (As 10 3 times in FID)
2	20	2 (As 20 2 times in FID) and so on
3	30	3
4	10	3
5	20	2
6	30	3
7	40	1
8	30	3
9	50	1
10	10	3

[vincent_ardiet]

Hi Patel,

Try this expression:

=count(TOTAL <FID> FID)

Regards,

Vincent

[Aurelien_Martinez]

Hi,

If you want to do that on expression:

Count(TOTAL <FID> FID)

If you want to do that on script:

TEST:

LOAD * INLINE [

ID, FID

1, 10

2, 20

3, 30

4, 10

5, 20

6, 30

7, 40

8, 30

9, 50

10, 10

];

Join(TEST)

TEST2:

LOAD

  FID,

  Count(FID)as tt

Resident TEST

Group By FID

;

Regards,

Aurélien

[israrkhan]

hi, PFA