Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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)
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)
Yes, you can use calculated dimension as =if(IsNull(Name),ID)
and tick Suppress when Value Is Null in chart properties.
Works just fine, thanks!