Syndicating Lookup multi value field data as multiple rows

[Former Member]

Hi Experts,

For one of the interface, we have syndication map designed.

1. Currently the interface sends multivalued lookup filed information of master record in single row. For example, if item I1 has S1, S2 and S3 as multi valued lookup field value ; syndication file will contain one record I1 S1,S2,S3
2. Requirement is to have as many rows for the master record as the number of multivalued lookup filed values. Taking above mentioned example,

I1  S1

I1  S2

I1 S3

Please guide.

Regards,

Ganga

[former_member196156 · Accepted solution]

Hi Gangadhar,

1. You need to create a tuple table with a text field or lookup table in the repository, note the multi-valued option has to be "no" for the field in the tuple table.
2. Now link the Tuple table by creating a new field in the specified main table and choose "yes"  for the Multi-valued option.

by following the above steps you can achive the below output.

I1  S1

I1  S2

I1 S3

kindly let me know if you require any more information.

Regards

Rahul

[Former Member]

Hi,

As Rahul explained, this is the only way through which your requirement is achieved.

However, i don't know whether u have PI in ur landscape to pick value from MDM.

If yes, a mapping logic could be designed in PI to achieve your requirement, without having any structural changes in MDM.

Regards, 

[Former Member]

Hi Ankit, Rahul,

Thanks for reply. We do not have PI in landscape.

Regards,

Ganga

[former_member196156]

Hi Ganga,

Then you need to use tuple as per to achive the below output.

I1  S1

I1  S2

I1 S3

Regards

Rahul