Map Multiple Fields from Single Source Record to Destination Tuple

[Former Member]

I have an Excel source file that contains multiple fields per record that need to go into MDM7.1 tuple on destination side.

As you see in this image, I have EFX_CERT1 mapped to the tuple.  I need to be able to map EFX_CERT2 as another entry in the destination tuple, but you cannot map multiple source fields to a single destination....or is there a way I don't know about?

     [file attached below too, in case too small inline]

Thanks,

Keith

[Former Member · Accepted solution]

Hi Keith,

Please attach the source preview for each of the 2 fields.

Any more data related information is welcome.

Thanks,

Ravi

[Former Member · Accepted solution]

Here is a sample or a source file that would apply to my "Like This" image above.

Thanks

[Former Member · Accepted solution]

Hi Keith,

As suggested in earlier post, you can concatenate source fields into single field in source file and then try to upload it in MDM system. It should work for you. Please try it and let me know the results.

Thank you.

[Former Member · Accepted solution]

Hi Keith,

Since you have two fields in your excel file and want to map it to a single tuple field in order to create two records I feel you should not concatinate. because if you do so you will not be creating two records in a tuple but a single record with both the values. something like in the Type field in Tuple their will be a single record as LBE;MBE

And you cannot map two source fields to a single destination field

I think the best way would be to alter your source file. Since it is an excel file it should not take more time.

Rgds,

Prasad

[Former Member · Accepted solution]

Thanks Prasad.  This is what it looks like to me.  I can't get concatenation to work as I need.

[Former Member · Accepted solution]

Hi Keith,

I think there is one small mistake that you are doing.

When your Name field in tuple already holds the classification type values corresponding to the 2 fields you should map to another a field with both values or repeating values.

What I mean is you should have a field Type (say) which can be multivalued in source or if you have excel then there should be 2 line items with same primary key but 2 different Type values LBE and MBE.The tuple update should be based on this Type value.

This way you will have one record at main table level and 2 at tuple level.

Thanks,

Ravi

[Former Member · Accepted solution]

Hi Keith,

Apologies that i could not understand your requirement earlier.

Since you want to add two rows in your tuple, then you should change your source file as suggested by Ravi. Instead of creating two different column names(EFX_CERT1 and EFX_CERT2 but use only single column EFX_CERT) for two values in tuple, you should include two rows for same record, where only Tuple values will be different i.e. MBE and LBE.

Thank you.

[Former Member]

Hi Keith,

You can combine your source fields and then map is to the required destination field

1. Select the Partitian Field/value Tab as the active Tab

2. Select the EFX_CERT1 and EFX_CERT2 and Press ADD and from the POP-UP select ADD as         Combination

3. Select the map field values tab and Map the Combined field to the required destination field

Hope this helps

Rgds,

Prasad

[Former Member]

I need the source values to populate separate destination records in the tuple....versus being concatenated into one.

Like this:

[Former Member]

Hi Keith,

As per my understanding, you want to create two tuple records in single import process.

To achieve your requirement, you need to alter your source file so that it should contain data in correct structure. What you can do is, concatenate the values of column EFX_CERT1 and EFX_CERT2, separated by some delimiter like "semicolon"(MDM uses default delimiter as ";" ), in single column in excel file. Similarly you need to do for EFX_CERTFRC1 and EFX_CERTFRC2 as well so that corresponding names could also be populated.

Then you can map first concatenated column to tuple field 'Type' and second concatenated column to tuple field 'Name'. Then try to import and it should solve your problem.

Kindly check this and let me know in case of any issues.

Thanks and Regards,

Ankush

[Former Member]

Hi Keith,

I am a little confused with the requirement. As initially you had asked that you want to map two source fields into one destination field

I have EFX_CERT1 mapped to the tuple.  I need to be able to map EFX_CERT2 as another entry in the destination tuple, but you cannot map multiple source fields to a single destination

Your reply

I need the source values to populate separate destination records in the tuple....versus being concatenated into one.

In case you want to populate seperate destination records in the tuple you can clone the required fields and map it as required

If you could provide a little bit more insight about your requirement we could figure a way out.

Or is it that you have two source fields and you want two records in the same tuple?

If yes, then you will have to alter your source file to achieve your requirement

Rgds,

Prasad