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.