Data Integrator - Create an XML file from a table.

dataservices job design
1

Hey guys,

I’m trying to create an XML file using a provided XSD schema from a table that I have.

I have the following structure in my XSD file:

  • Transactions (the root element that is hidden in the Schema Out)
    • Transaction (with each nested item below, being part of a transaction)
      1. Nested A
      2. Nested B
      3. Nested C
      4. Nested D

I’ve done the row generation correctly, I believe, starting at Row number 0, with a count of one. Nested B, C and D are mapped in my From clause are grabbing information from my tables, and it’s cartesianing when it prints the XML file (1 nested element for each row in my table). But my desired output is one Transaction per row. I understand why it’s happening, but don’t know how to actually implement a fix.

I tried looking through some documentation online for SAP BODS with XML and found anything that helps my situation.

Thanks!

Vernon

vernong1992 (BOB member since 2017-03-01)

2

Can you give a sample example of what you are trying to do??

Jay_mKumar :india: (BOB member since 2016-03-24)