topic count of non matching values in App Development

count of non matching values

pala_jagadeesh — Mon, 04 Jul 2022 05:18:27 GMT

I want count of mismatching values form below table,

like I want Total count of mismatch item ie,( count of Orange,Banana,Grape because these three are not present in three columns)

Item	col1	col2	col3
Apple	Apple	Apple	Apple
Orange	Orange	-	Orange
Banana	-	-	Banana
Grape	-	-	Grape

output

count_of_mismatch

when I click on this count i want to show what are they

Re: count of non matching values

sidhiq91 — Mon, 04 Jul 2022 05:12:36 GMT

@pala_jagadeesh Could you please elaborate on your requirement, sorry I could not understand. It could be even better if you can provide some sample data and expected output.

Re: count of non matching values

pala_jagadeesh — Mon, 04 Jul 2022 05:25:14 GMT

Hi @sidhiq91 I want count of items which are not present in three columns(it should be present in three columns, if not present , i want that items count)

if i click on that count ,its shows what are they

here Orange ,Banana and Grape are not present in three columns

only apple was present in three columns

So i want count of items (Orange ,Banana and Grape) as output as

count_of_mismatch