XML Child Elements are repeating multiple times
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 :-
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.