You are not logged in.
I am using JasperETL(3.2.3.r35442) to extract data from a xml file and put it into mysql table.
I have an xml file similar to:
<CompareState>overall site performance (% of Site Total).</CompareState>
<Name>Please help me</Name>
While extracting the desired fields from the file, I would like to extract just the 2nd <Detail> element alone (ABC). I want XXX to be ignored. In this case, I cant use <Detail> node for Xpath loop expression because, I have already set some other element in the xml file as the Xpath loop expression.
When I just drag the <Detail> element into the Field to extract column, I get XXX all the time (since it is the first element). I am not able to loop to the ABC.
Is there a solution for this??
Kindly help me out here please!!
Thanks a million in advance!!
Last edited by gokul (2010-07-08 07:01:51)