BusinessObjects Board

Eliminate duplicates in generated XML at line item level

dataservices realtime
#1

Hi Forum members,

We have a unique requirement in our project to load data in a XML from a relational table.
We have source data in below format. Sales order and sales id are unique columns.
Sales_Order Sales_ID Name Address Quantity
7001 1 George US 1
7001 1 John UK 2
7001 1 Peter IN 3

We need to store this data in xml. I have put the data manually in xml and attached the same. XSD/metadata is also attached.

Currently we are able to load the data but it is getting duplicated at the line item level. Also attached the current XML output. Any help is highly appreciated.
source_data_snapshot.PNG
sample_xsd_and_xml.zip (1.0 KB)

siddharthkr1 (BOB member since 2014-11-21)

#2

Please go through the below link for more understanding of NRDM:
http://wiki.scn.sap.com/wiki/display/EIM/The+Nested+Relational+Data+Model+NRDM

Along with it, You need to maintain hierarchy in data flow before putting XML target. You can use row_gen transform for the same.

Thanks

fastkumar09 :india: (BOB member since 2012-06-30)