topic Re: Compare two fields in App Development

Compare two fields

Nagaraju_KCS — Wed, 21 Jun 2023 12:45:57 GMT

Hi Experts,

I have to take ID count and have to compare between String and Compare String (like we have one to many association)

but for example - here I have to take count same in both the fields - so output should be 25

=COUNT(Aggr(COUNT( {<String=P([Compare String])>} DISTINCT ID),ID)) - this expression not giving correct result

70 is taking all the 4 records count, but it should be count for same records.

I'm expecting below result with out selection compare string

Note: only the matching selections should be calculated between the two fields.

Thanks in Advance!

Chanty4u — Tue, 20 Jun 2023 18:14:22 GMT

Modify like this

COUNT( {<String=P([Compare String]), ID={"=Count(DISTINCT String) = Count(DISTINCT [Compare String])"}>} DISTINCT ID)

Kushal_Chawda — Tue, 20 Jun 2023 22:41:11 GMT

@Nagaraju_KCS If you have primary Key in table then try below expression.

=count({<Primary_Key= {"=String=[Compare String]"}>}DISTINCT ID)

If you don't have primary Key then you can create it using RowNo() function in script

LOAD RowNo() as Key, [Compare String], ID, String FROM Data; then below expression =count({<Key= {"=String=[Compare String]"}>}DISTINCT ID)

If you don't want to create key in script then simply try below expression

=COUNT(distinct if(String=[Compare String],ID))

sidhiq91 — Wed, 21 Jun 2023 04:09:41 GMT

@Nagaraju_KCS You can try the below expression:

count (distinct if(string=[Compare String]) ,ID))

Let us know if this has resolved your issue.