Skip to Content
avatar image
Former Member

Multivalued Import

Hi All,

Please guide me in importing data in a multivalued flat field.

Source

1000,2000

2000,3000

MDM rep

Lookup MV field(FieldX)

1000

2000

3000

I want in the MDM rep

mat num Desc Lookup MV field

ABC ABC desc 1000,2000

Thanks

AJ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 23, 2009 at 02:01 PM

    Hi all,

    I know now how to map Multivalued lookup fields value in MDM.

    I wish to know is there a way to auto map this automatically each time i open the map.

    My source file can have any combination of values for the given MV field

    say 1000,2000

    3000,4000

    3000,1000

    all these values are valid values in my Lookup table however i want that each time i have a new unique combination it should get automapped to the destaination value.

    Thanks

    AJ

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Amruta,

      There are 2ways in which this can be achieved -

      1. Map these values manually for the first time and save them in the map. Nex time you use the map,these values get auto mapped.

      2. Enable remote keys and refresh remote keys with their values. Auto value mapping works .

      Regards,

      Vinay M.S

  • avatar image
    Former Member
    Nov 17, 2009 at 03:59 PM

    Using the Import Manager you can set the multi-value delimiter in two ways:

    1) Configuration > Options > Default value delimiters, and set the Multi-Valued [MV] value

    2) Under Map Fields/Value tab, before mapping a field in the Source, right-click and select Set Field Mapping Delimiter > Multi-Valued

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2009 at 04:50 PM

    HI Amruta

    You need to split the source field in import manager using a delimiter- in this case this is ","

    Once you have splitted the field and this can be mapped to destination multi valued lookup field. For more details pls refer to import manager reference guide.

    regards

    Ravi

    Add comment
    10|10000 characters needed characters exceeded