topic Re: Count Duplicate Field 2 from a Table in App Development

Count Duplicate Field 2 from a Table

rpavan17 — Sat, 16 Nov 2024 19:55:30 GMT

Hi,

I have Field 1 and Field 2 in a Table.

Field 1, Field 2

Orange, O1

Orange, O2

Green, G1

Green, G2

Yellow, O1,

Purple, O1

Like above, i need to find which is field 2 is duplicated and how many times it is duplicated?

Expected Answer is O1 is duplicated and 3 times.

Thanks in advance

Re: Count Duplicate Field 2 from a Table

Anil_Babu_Samineni — Thu, 10 Oct 2019 08:09:32 GMT

Perhaps this?

Count({<[Field 2]={"=Count([Field 2])>1"}>} [Field 2])

Re: Count Duplicate Field 2 from a Table

rpavan17 — Thu, 10 Oct 2019 08:21:36 GMT

It did not work.

Re: Count Duplicate Field 2 from a Table

Anil_Babu_Samineni — Thu, 10 Oct 2019 08:35:55 GMT

What is the exact output and where?

Re: Count Duplicate Field 2 from a Table

Mauritz_SA — Thu, 10 Oct 2019 09:01:44 GMT

Hi there

Maybe not exactly what you want, but AGGR(Count([Field 2]),[Field 2]) will give you the number of times that Field 2 appears. If you use it with your Field 2 then you can easily manipulate it to only give you the values where it appears more than once.

Regards,

Mauritz

Re: Count Duplicate Field 2 from a Table

StarinieriG — Fri, 18 Oct 2019 16:00:58 GMT

Hi,

could you do it inside the script?

TABLE:
LOAD * Inline [
Field 1, Field 2
Orange, O1
Orange, O2
Green, G1
Green, G2
Yellow, O1
Purple, O1
]
;

Left Join (TABLE)

LOAD *

If(Count_field_2>1,'duplicated','not duplicated) as flag

;
LOAD
[Field 2],
Count([Field 2]) as Count_field_2
Resident TABLE
Group By
[Field 2]
;