Count instances of values of a table in another table

[RyugaHideki]

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 

[Kushal_Chawda]

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

[RyugaHideki · Accepted solution]

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 

[seanbruton]

Superb !!! Neat Solution.