https://community.qlik.com/t5/Talend-Studio/Talend-s-FileInputXML-and-Xpath-2-0/m-p/2339957#M108039 Hello <BR />Talend doesn't support a xpath as you set, for now, you can set the xpath as below, extract all the records and filter the records on tMap <BR />/root/body/data/invoice <BR />Best regards <BR /> <BR /> shong Wed, 21 Oct 2009 09:19:11 GMT Anonymous 2009-10-21T09:19:11Z https://community.qlik.com/t5/Talend-Studio/Talend-s-FileInputXML-and-Xpath-2-0/m-p/2339956#M108038 Hey folks, <BR />I'm trying to parse a xml input file via the FileInputXML component. However, my Xpath 2.0 expression (tested in XMLSpy) will not work in Talend: <BR />- The xpath is as follows in XML Spy: <BR /> (if(exists(//data/invoice)) then (//data/invoice) else (//data/invoice)) <BR />- The xpath is as follows in Talend (escaped cause its a String in Talend): <BR /> "(if(exists(//data/invoice)) then (//data/invoice) else (//data/invoice))" <BR />The exception I get indicates (imho) a mismatch between the component and xpath 2.0. So my question is a) does de component actually support xpath 2.0 and b1) if not, is there a viable alternative or b2) it does, what am I doing wrong? <BR />I've added 2 example input xml files and the expected result in pseudo xml to indicate what I'm trying to achieve: <BR />- In the non YK file there are multiple invoice elements, none of them with an object-id that starts with YK. So I expect Talend to loop over each invoice element. <BR />- In the YK file there are also multiple invoice elements, but one of them has an object-id that starts with YK. So I expect Talend to only that specific invoice element. <BR />The Talend exception: javax.xml.transform.TransformerException: Could not find function: if <BR /> at com.sun.org.apache.xpath.internal.compiler.XPathParser.error <BR />I hope I explained it enough and thanks in advance for the help. <BR />Regards Roel Sat, 16 Nov 2024 13:43:44 GMT https://community.qlik.com/t5/Talend-Studio/Talend-s-FileInputXML-and-Xpath-2-0/m-p/2339956#M108038 Anonymous 2024-11-16T13:43:44Z https://community.qlik.com/t5/Talend-Studio/Talend-s-FileInputXML-and-Xpath-2-0/m-p/2339957#M108039 Hello <BR />Talend doesn't support a xpath as you set, for now, you can set the xpath as below, extract all the records and filter the records on tMap <BR />/root/body/data/invoice <BR />Best regards <BR /> <BR /> shong Wed, 21 Oct 2009 09:19:11 GMT https://community.qlik.com/t5/Talend-Studio/Talend-s-FileInputXML-and-Xpath-2-0/m-p/2339957#M108039 Anonymous 2009-10-21T09:19:11Z https://community.qlik.com/t5/Talend-Studio/Talend-s-FileInputXML-and-Xpath-2-0/m-p/2339958#M108040 Maybe you can request for this feature in the bug tracker, it would need to use the library saxon (for instance) for parsing. Wed, 21 Oct 2009 09:51:06 GMT https://community.qlik.com/t5/Talend-Studio/Talend-s-FileInputXML-and-Xpath-2-0/m-p/2339958#M108040 Anonymous 2009-10-21T09:51:06Z