How to get records from table a that is not in table b with a condition

[Anonymous]

I have two tables: data and expected_data and want to visualize missing_data wither through direct visualization or through creating a table.

Example:

data

_Today	name
True	A
False	B
True	C

expected_data

name

A

B

C

desired missing data (given that _today is False). This is also the end visualization -> a list of values that is not present in data but in expected_data.

name

B

[Anonymous · Accepted solution]

Hi @Anonymous 

I suggest you to create a relationship between two tables by Name columns.

Then create a table visual by [Name] from "expected_data" table, drag [_today] into filter field in this visual and selet "False".

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VijayP]

@Anonymous 

I think some more data (dummy atlest) required to answer this query.

In the above examples both tables contain B , so what is the logic to bring B in desired result