XML output formatting.
Posted: Mon Mar 21, 2011 4:04 pm
Some data elements in my xml out file is getting repeated for all the columns, my requirement is it should appear only once in the beginning followed by all the rows from the DB source.
See below 3 rows of data , the black highlighted on
It should be shown only once in the beginning as this is constant,doesnt makes sense to repeat for all the rows.
let me if this is possible in XML output stage.
- <row>
- <file_audit_data>
<Create_date>15786</Create_date>
<create_by>XYZ</create_by>
<version>1</version>
<file_number>1.1</file_number>
</file_audit_data>
- <registry>
<registry_name>PROJECT NAME</registry_name>
<registry_id>123456</registry_id>
<submission_method>C</submission_method>
</registry>
<mid>NQssF 0495_1</mid>
<measure>EDddd-1 1</measure>
<eligible>16</eligible>
<performance>28</performance>
</row>
- <row>
- <file_audit_data>
<Create_date>15786</Create_date>
<create_by>XYZ</create_by>
<version>1</version>
<file_number>1.1</file_number>
</file_audit_data>
- <registry>
<registry_name>PROJECT NAME</registry_name>
<registry_id>123456</registry_id>
<submission_method>C</submission_method>
</registry>
<mid>Ndff 0495_2</mid>
<measure>EDdd-1 2</measure>
<eligible>9</eligible>
<performance>34</performance>
</row>
- <row>
- <file_audit_data>
<Create_date>15786</Create_date>
<create_by>XXX</create_by>
<version>1</version>
<file_number>1.1</file_number>
</file_audit_data>
- <registry>
<registry_name>PROJECT NAME</registry_name>
<registry_id>123456</registry_id>
<submission_method>C</submission_method>
</registry>
<mid>Nas 0495_3</mid>
<measure>EDdd-1 3</measure>
<eligible>6</eligible>
<performance>39</performance>
</row>
The tag file_audit_data and registry should appear only once, the real data is mid,measure,eligible,performance
See below 3 rows of data , the black highlighted on
It should be shown only once in the beginning as this is constant,doesnt makes sense to repeat for all the rows.
let me if this is possible in XML output stage.
- <row>
- <file_audit_data>
<Create_date>15786</Create_date>
<create_by>XYZ</create_by>
<version>1</version>
<file_number>1.1</file_number>
</file_audit_data>
- <registry>
<registry_name>PROJECT NAME</registry_name>
<registry_id>123456</registry_id>
<submission_method>C</submission_method>
</registry>
<mid>NQssF 0495_1</mid>
<measure>EDddd-1 1</measure>
<eligible>16</eligible>
<performance>28</performance>
</row>
- <row>
- <file_audit_data>
<Create_date>15786</Create_date>
<create_by>XYZ</create_by>
<version>1</version>
<file_number>1.1</file_number>
</file_audit_data>
- <registry>
<registry_name>PROJECT NAME</registry_name>
<registry_id>123456</registry_id>
<submission_method>C</submission_method>
</registry>
<mid>Ndff 0495_2</mid>
<measure>EDdd-1 2</measure>
<eligible>9</eligible>
<performance>34</performance>
</row>
- <row>
- <file_audit_data>
<Create_date>15786</Create_date>
<create_by>XXX</create_by>
<version>1</version>
<file_number>1.1</file_number>
</file_audit_data>
- <registry>
<registry_name>PROJECT NAME</registry_name>
<registry_id>123456</registry_id>
<submission_method>C</submission_method>
</registry>
<mid>Nas 0495_3</mid>
<measure>EDdd-1 3</measure>
<eligible>6</eligible>
<performance>39</performance>
</row>
The tag file_audit_data and registry should appear only once, the real data is mid,measure,eligible,performance