Hi ALL,

I am new to kettle 3.2. i need to read the data from xml to oracle table.

After i get the data from xml, I am getting the <subject> tags like subject, subject_1,subject_2,...... in select values.

i need to insert all the subject for each students in a single table.like as below

ID Name Subject
1 John English
 1 John French
1 John Maths
1 John Science
2 NeilEnglish
.............

<school>
<schoolname>St James</schoolname>
<class>5</class>
<students>
<student>
<name id=1>John</name>
<subjects>
<subject>English</subject>
<subject>French</subject>
<subject>Maths</subject>
<subject>Science</subject>
</subjects>
</student>
<student>
<name id=2>Neil</name>
<subjects>
<subject>English</subject>
<subject>Spanish</subject>
<subject>Maths</subject>
<subject>Science</subject>
</subjects>
<student>
<students>
</school>

please help me to solve this issue.