XML Child Elements are repeating multiple times

Hi Team,

I'm currently facing issue while developing an ETL job.
I need to generate Output in XML format, but the Child Elements are getting duplicated.

For Example :-

AlertID<Parent Element>

<Attachment>
<AlertDetails>

If Attachment element has 5 different records, then Alert Details is also getting repeated for 5 times with same data.

Request you to help with it.

In XSD I have mentioned maxoccurs as unbounded for both the child elements and there might be cases were alert details have different records and attachment is getting repeated with same data.

Regards,

Rahul Jain

Answers

  • Karen Weir
    Karen Weir E Community Administrator

    Thanks for posting @Rahul Jain . Can you please confirm which OpenText product you are using? I can then move your inquiry to the best spot, or direct you to a resource on My Support.