Import failed with multivalued tuple fields 7.1 sp4

[Former Member]

Hi All,

We have a issue while loading the data in to Main table and Multivalued tuples.

we want to import two fields from main table along with 3 fields from multivalued tuple for a record.

Ex: Main table fields ( ID, Name) and Tuple values( ID, Name1, Name2 and Name Type) this is multivalued.

01, test, 001, tuple test1, tuple test2, xxx

tuple test3, tuple test4, abc

now we have 3 scenarios to

1. In tuple vaues, If an empty tag comes whats the behaviour

2. If the tag doesnot exist in xml whats the beaviour

3. If there were 3 values.. in the intial load, and now only 2 values are coming in that case it has to delete the 3rd value.... how to achieve this functionality.

thanks in advance

Anil

[Former Member]

Hi Anil,

1. In tuple vaues, If an empty tag comes whats the behaviour
2. If the tag doesnot exist in xml whats the beaviour

For these two questions, i am giving you example with Text Delimited comma separated file.

Your Source file should be like this as shown below, lly you can correlate it with XML file.

IDM,NameM,IDT,Name1T,Name2T,NameTypeT
01,test,001,tuple test1,tuple test2,xxx
01,test,,tuple test3,tuple test4,abc

Here for second tuple record as shown above, IDT tag value is missing, so when you upload this file in Import Manager, in source preview you will have structure like this as shown below:

IDM      NameM      IDT      Name1T        Name2T     NameTypeT
01       test       001     tuple test1  tuple test2   xxx
01       test               tuple test3  tuple test4   abc

So after importing there will be 2 records for your Tuple and for 2nd tuple record IDT field of your tuple MDM will remain empty. I mean same structure will be there for your tuple as shown above for Import Manager Source preview except fields IDM and NameM as these are main table fields not Tuple fields.

If there were 3 values.. in the intial load, and now only 2 values are coming in that case it has to delete the 3rd value.... how to achieve this functionality

For this you need to set this property in MDM Import Manager>Configuration Options>Default Tuple update

                  ..Matching Tuple fields             None
                  ..New records option                Create   
                  ..Existing records option           Replace

Just check and revert with Result

Regards,

Mandeep Saini