I am running profile import workflow where my cvs file will have columns like
Email; Name; DesignationRoles
in this we have designationroles will have multiple values as comma separated. The values will be in short form so I have been asked to create a custom resource cusDesigRoles which will have two columns (key, value) where key is the short form and value is abbreviated form.
cusDesigRoles table will have some 100 designation like below and I loaded the table with 100 designations.
TM Team manager
AE. AEM engineer
CM CAmpaign engineer
How to map my custom profile resource with chaDesigRoles table. It is like N:N relationship. And very importantly, we should provide a feasibility to change/add designationRoles for a profile in detailed screen window for a profile edition. Ex: “CM” designRole can be added to profile “Divya” in future. Refer the sample table above.
kindly let me know how I can achieve this. What type of join condition I should use and in import workflow how to parse comma separated values for a designationRoles and map it to cusDesigRoles resource.