Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi Patel,
Try this expression:
=count(TOTAL <FID> FID)
Regards,
Vincent
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
hi, PFA