tExtractXMLField returns same firstname instead of moving to next firstname tag

[Cherichoc-]

I have an the below xml file . My job is tFileInputXML--->tExtractXMLField--->tlog

 

My tExtractXMLField is set as the below. It keeps returning the Only the first firstname for all the other rows instead of the expected results. How can I set it to return only

 

<root><status>success</status>   

   <data><users><firstname>Abby</firstname>

          <book><name>ABC</name> 

              <state><complete>true</complete></state>

          </book>

          <book><name>ZZZ</name>

              <state><complete>true</complete></state>

          </book> 

      </users>

      <users><firstname>Abdul</firstname>

         <book><name>SeeSaw</name>               

              <state><complete>true</complete></state>

         </book>

         <book><name>WWW</name>

              <state><complete>true</complete></state>

         </book>

       </users>

     </data>

</root>

[Anonymous]

Can you show your full tExtractXMLField configuration please?

[Cherichoc-]

[Anonymous · Accepted solution]

Change firstname to ....

"../firstname"

[Cherichoc-]

Thank you, it worked. I definitely need to learn more about xPath 🙂