Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to append multiple foreign key into entity in Talend MDM

Hi,
I have input file with below details. 
"Attribute_in_name","unique_key_flag","mandatory_flag","lov_value"
"suitable_for_bifocals","Yes","Yes","Yes"
"suitable_for_bifocals","Yes","Yes","No"

I have loaded the distinct Attribute_in_name, unique_key_flag and mandatory_flag into attributedefinition entity in talend MDM. 
Now i need to lookup for key in lovname entity which as value as "Yes" and "No" and get the key from lovname entity and append it in attributedefinition  entity.
there  may 1 to N foreign key to append. 
could you please let me know how can i append multiple foreign key to the existing entity attributedefinition in which already mandatory data is present using DI jobs?
In attached screenshot Foreign key values need to be appended as shown below under AllowedValues with allowedvalueFK (AllowedvalueFK can have 1 to N numbers and it is dynamic, varies for each records of attribituedefintion.
Please note other details in attributedefinition entity loaded before we append the allowedvalues.
0683p000009MC9r.png
Thanks for your help!
Thanks
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Can anyone help me on this please?
Thanks