Attaching Child Entities To Parents when FID is unknown
S
Subham Dixit
started a topic
about 2 years ago
I have two entities
I want to link them based on the matching tag attribute. When loading entries into the streaming tags entity, how do I find the value needed for the log equip foreign field?
Best Answer
S
Subham Dixit
said
about 2 years ago
if my understanding is correct, you want to load StreamingTags using the "Matching Tag" as a reference to your LogEquip entity, then use this to populate properly your FID_LogEquip, right?
Mapping Table, Lookup Column, and Output Columnas Plug-in Params, pointing to your LogEquip GD table
MatchingTag as Input Lookup Value
FID_LogEquip as Output Value #1
Sample Lookup Enricher configuration
set its Enrichment Scope to Pre-consolidation only so that the job triggers your enricher during the certification process.
you might need additional configurations like Fallback Behavior and Fallback Value Plug-in Params in the case where the parent entity does not find any result.
So after completing the above settings and deploying your model, you can see the output is putting the same MatchingTag value in both the child and parent entity records, so here you can see the FDN_LogEquip column value which points to the parent entity record.
1 Comment
S
Subham Dixit
said
about 2 years ago
Answer
if my understanding is correct, you want to load StreamingTags using the "Matching Tag" as a reference to your LogEquip entity, then use this to populate properly your FID_LogEquip, right?
Mapping Table, Lookup Column, and Output Columnas Plug-in Params, pointing to your LogEquip GD table
MatchingTag as Input Lookup Value
FID_LogEquip as Output Value #1
Sample Lookup Enricher configuration
set its Enrichment Scope to Pre-consolidation only so that the job triggers your enricher during the certification process.
you might need additional configurations like Fallback Behavior and Fallback Value Plug-in Params in the case where the parent entity does not find any result.
So after completing the above settings and deploying your model, you can see the output is putting the same MatchingTag value in both the child and parent entity records, so here you can see the FDN_LogEquip column value which points to the parent entity record.
Subham Dixit
I have two entities
I want to link them based on the matching tag attribute. When loading entries into the streaming tags entity, how do I find the value needed for the log equip foreign field?
if my understanding is correct, you want to load StreamingTags using the "Matching Tag" as a reference to your LogEquip entity, then use this to populate properly your FID_LogEquip, right?
Then you can
Sample Lookup Enricher configuration
So after completing the above settings and deploying your model, you can see the output is putting the same MatchingTag value in both the child and parent entity records, so here you can see the FDN_LogEquip column value which points to the parent entity record.
Subham Dixit
if my understanding is correct, you want to load StreamingTags using the "Matching Tag" as a reference to your LogEquip entity, then use this to populate properly your FID_LogEquip, right?
Then you can
Sample Lookup Enricher configuration
So after completing the above settings and deploying your model, you can see the output is putting the same MatchingTag value in both the child and parent entity records, so here you can see the FDN_LogEquip column value which points to the parent entity record.
-
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 274 topics