Showing the values that don't occur in the 1-to-many relationship table

[Anonymous]

Hi,

I have 2 tables with a 1-to-many relationship. Now I want a list of all values that occur in the first table (1) and not in the second table (many). How do I do that?

[v-juanli-msft]

Hi @Anonymous

I test with an example

What result do you want?

Best Regards

Maggie

[Anonymous]

In table 2 there are categories that don't occur in table 1, e.g. 'e'.

I'd like to filter on number BLANK of table 1 to get a list of all categories in table 2 without a number.