One Star

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.

Thanks for your help!
Thanks
1 REPLY
One Star

Re: How to append multiple foreign key into entity in Talend MDM

Can anyone help me on this please?
Thanks