Datahub: Creating multiple rows in Hybris table from repeating segments in idoc

[rahulverma94]

Hi Experts,

We have a repeating segment(E1MARMM) inside the parent segment E1MARAM. The repeating segment E1MARAM-E1MARMM have multiple fields e.g A,B,C,D,E.

My requirement is to publish these field values from each segment (E1MARAM-E1MARMM) as a unique row in my Hybris target table i.e if we have 5 repeating segments, we should be having 5 rows in target Hybris table with the respective field values from each segment.

How can we achieve this?

Regards Rahul

[former_member623616 · Accepted solution]

You can define corresponding E1MARAM-E1MARMM attibute as primary key and combination of primary key should be unique.

Thanks, Yaten

[rahulverma94 · Accepted solution]

Even after declaring the fields as primary key, datahub only picks the fields from last E1MARAM-E1MARMM segment and not all the segments. I want to have 5 rows(each row having values from corresponding E1MARAM-E1MARMM segment fields) in target Hybris table if we have 5 E1MARAM-E1MARMM segments.

[former_member224482 · Accepted solution]

As Yatendra mention, a field in E1MARMM shall be chosen as being unique to distinguish the other E1MARMM rows.

Documentation around section of : Choosing Canonical Items

[rahulverma94 · Accepted solution]

Thanks and for the inputs. It worked.