Hi all,
I am new to xml and need to produce an xml output from pentaho like below.


<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<crewDetails>
<crewInfo crewId="45345345">
<personalInfo>
<searchName>sert tyur</searchName>
<firstName>GTYH</firstName>
</personalInfo>
</crewInfo>
</crewDetails>


i used add ml and xml joints to produce the output.


In the first xml join i get the output : <?xml version="1.0" encoding="UTF-8"?><crewDetails><crewInfo crewId="789456"/></crewDetails>
XPath statement //crewDetails


In the second xml join , i am getting error :XPath statement returned no result
Xpath statement tried :
1. XPath statement returned no result [//crewInfo[@crewId]]
2. XPath statement returned no result [/crewDetails/crewInfo[@crewId]]


I have no clue how to put complex join here.

My pentaho transformation is like below.

input xmladd (<crewDetails/>)
input xmladd2(crewid) xmljoin
input xmladd3(personalInfo) xmljoin2


Anyhelp is appreciated.





Thank You,
Vini