Hello, In my golden data, I would like to filter into my master records based on an exclusion. My masters contain Activity : A,B,C some of them are only A, some A, B or A, C. When I apply filter (advanced filter) containing Activity = A, my result contains rows with Activity A and also master with A, B or A, C. I tried to apply filter Activity <>B or Activity <>C but it doesn't work. Filter with SemQL is also not convincing me. Any idea ?
Best Answer
S
Stéphanie FOURRIER
said
over 2 years ago
You can treat Master Records as if they are related through references, except they are not related through entities but through record lineage relationships.
Example: Source --> Master --> Golden.
So like child entities, you can see Master Records like a child lineage. Therefore you will have to use the ANY or ALL syntax to filter golden records.
ANY MasterRecords HAVE ( Activity = 'A' )
AND NOT ANY MasterRecords HAVE ( Activity = 'B' )
1 Comment
S
Stéphanie FOURRIER
said
over 2 years ago
Answer
You can treat Master Records as if they are related through references, except they are not related through entities but through record lineage relationships.
Example: Source --> Master --> Golden.
So like child entities, you can see Master Records like a child lineage. Therefore you will have to use the ANY or ALL syntax to filter golden records.
Stéphanie FOURRIER
Hello, In my golden data, I would like to filter into my master records based on an exclusion. My masters contain Activity : A,B,C some of them are only A, some A, B or A, C. When I apply filter (advanced filter) containing Activity = A, my result contains rows with Activity A and also master with A, B or A, C. I tried to apply filter Activity <>B or Activity <>C but it doesn't work. Filter with SemQL is also not convincing me. Any idea ?
You can treat Master Records as if they are related through references, except they are not related through entities but through record lineage relationships.
Example: Source --> Master --> Golden.
So like child entities, you can see Master Records like a child lineage. Therefore you will have to use the ANY or ALL syntax to filter golden records.
You can see examples of these in lineage child records.
Stéphanie FOURRIER
You can treat Master Records as if they are related through references, except they are not related through entities but through record lineage relationships.
Example: Source --> Master --> Golden.
So like child entities, you can see Master Records like a child lineage. Therefore you will have to use the ANY or ALL syntax to filter golden records.
You can see examples of these in lineage child records.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 263 topics