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"?>
<crewInfo crewId="45345345">
<searchName>sert tyur</searchName>

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,