I have a question regarding Partitioning values in MDM Import Manager. I've a tab-delimited file with the following structure
Field 1|Field 2
Field 2 in the file is mapped to a (multi-valued) field which looks up into a qualified table and contains values 1,2,3 4,5,6,7,8,9.
I want to update the main table with multiple values, but the values come under a single column. Is there any way by which I could split the values, and map each values individually to the destination value. Field level splitting would not help me in this case, since all the fields have to be ultimately mapped to one destination value (which would not be possible).
I'm not sure if this scenario is possible in MDM. Any help would be appreciated.
Thanks & Regards