Hello,
please help me, how to correctly write this SELECT in MAQL.
SQL:
select count(*) FROM table_a WHERE NOT EXISTS(select * FROM table_b WHERE table_b.id_table_a = table_a.id_table_a)
Thank you very much
Petr
Best answer by Joseph Heun
View original
The COUNT function can be used specifically on attributes. You can filter your metric using a WHERE Clause; using “ <>” as the operating symbol for does not equal.
Please, can you write example for my SQL.
It could look something like this:
Select COUNT (attribute, connection point) where attribute <> attribute_value
I’m afraid that if you are looking to use a left outer join, like in SQL, it is not possible. We always use inner join by default. It is not possible to define what type of join is used when data are read into reports from connected datasets.
I understand.
What do you recommend ?
TABLE A
id_a INT - primary key
TABLE B
id_b - primary key
id_a - reference key to TABLE A
I need find out count FROM table A, which doesn't have relation into table B.
Thank you for help
It may help if you were to provide a screenshot of your LDM and the insight/metric you are currently working with.
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
