# XML data load to Oracle table with Metadata

**URL:** <https://forum.cloverdx.com/t/xml-data-load-to-oracle-table-with-metadata/1301>\
**Category:** CloverDX Platform\
**Created:** [November 9, 2013, 12:00am UTC](https://forum.cloverdx.com/t/xml-data-load-to-oracle-table-with-metadata/1301 "2013-11-09T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jinojohn](https://avatars.discourse-cdn.com/v4/letter/j/ccd318/32.png) [@jinojohn](https://forum.cloverdx.com/u/jinojohn)\
**Post date:** [November 9, 2013, 12:00am UTC](https://forum.cloverdx.com/t/xml-data-load-to-oracle-table-with-metadata/1301/1 "2013-11-09T00:00:00Z")

</div>

Hello CloverETL Users, I have a question on

I am trying to load the XML produced in XMLWriter into the Oracle table which is of below structure

ID NUMBER(16,0)  
PRIOR\_TRANSACTION\_ID VARCHAR2(30 BYTE)  
CREATE\_DATE DATE  
UPDATE\_DATE DATE  
ERROR\_CODE VARCHAR2(50 BYTE)  
PAYLOAD CLOB

I am able to load the CLOB column alone by connecting the output port of XMLWriter to DBOutputtable , But how can I bring the other columns associated and write them into the table at the same time.

i.e. How I can load

ID,PRIOR\_TRANSACTION\_ID,CREATE\_DATE,UPDATE\_DATE and ERROR\_CODE from other sources and XML produced from XMLwriter as PAYLOAD to the oracle table .

Any quick response will be really appreciated.

---

<div class="post-metadata">

**Author:** ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)\
**Post date:** [November 11, 2013, 3:13pm UTC](https://forum.cloverdx.com/t/xml-data-load-to-oracle-table-with-metadata/1301/2 "2013-11-11T15:13:58Z")

</div>

Hello jinojohn,

I think the component you are looking for is Combine, [http://doc.cloveretl.com/documentation/ … mbine.html](http://doc.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/combine.html)

It is able to join records in two separated input streams according to the order. The first record in input A is joined to the first record in input B, the second one in A is joined to the second one in B and so on…

Does this solution meet your requirement?

Kind regards,