topic Re: Count instances of values of a table in another table in App Development

Count instances of values of a table in another table

RyugaHideki — Fri, 15 Nov 2024 20:50:50 GMT

Hello

Say we have a table of vegetables that i created something that has values like TABLE A "potato","tomato","onion"
and another tables that has repeated instances of these very values TABLE B like a survey for example where it shows what every customer bought i want to count the instances of each value of table A in TABLE B how can i do that

I need this cause i want to create a dimension of it so i could display them individually or filter them

Re: Count instances of values of a table in another table

Kushal_Chawda — Sat, 26 Oct 2024 18:56:49 GMT

@RyugaHideki What exactly you want to count? Could you please share example with dummy data?

Re: Count instances of values of a table in another table

RyugaHideki — Sat, 26 Oct 2024 19:00:51 GMT

I actually found a solution

Count(If(WildMatch(TableA, TableB), TableA))

for those who want to know and for the dummy data it's something like this
Table:

load* inline[

"Carrot",

"Broccoli",

"Spinach"]; the other table is just instances of these values like repeated

Re: Count instances of values of a table in another table

seanbruton — Fri, 01 Nov 2024 15:48:21 GMT

Superb !!! Neat Solution.