Skip to Content
0
Former Member
Feb 25, 2010 at 11:57 AM

MDM Import Manager - Value level splitting

23 Views

Hi Friends,

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

100|1;2;3;4;5

101|1;3;5;7;9

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

Anil Madhavan