Unmatching records without modifying the loading script

[amigo007]

I have 2 tables joined with a field called ID, I have e.g. a table A and table B as shown below. How can I list in a straight table the non-matching records, i.e. records with ID 5, 6 and 7 from table B?

Ideally, I don't want to make the unmacthing/changes to my loading scripts. Is there any kind of expression to make this listing inside a table object?

Table A:

ID	Name	City	Country
1	John	London	England
2	David	Paris	France
3	Jenny	Berlin	Germany
4	Mark	Rome	Italy

Table B:

ID	Cost
1	1000
2	1500
3	3000
4	500
5	6000
6	7000
7	5500

[tresesco · Accepted solution]

If you can find a candidate key in table A, assume field Name here, you could try like:

Calc dimension: If( Isnull(Name), ID)

Exp: Sum(Cost)

[shiveshsingh]

Yes, you can use calculated dimension as =if(IsNull(Name),ID)

and tick Suppress when Value Is Null in chart properties.

[amigo007]

Works just fine, thanks!