https://community.qlik.com/t5/Talend-Studio/Xpath-in-tExtractJsonFields-giving-incorrect-output/m-p/2324694#M94367 <P>Hello. I used Xpath for retrieving JsonFields as shown on the forum. However, the output is in the form of name-value pair which is not like the one shown on Talend Forum.<BR />The output is as follows:-<BR />.-------------+-----------+-----------------+------------------.<BR />| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;tLogRow_1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<BR />|=------------+-----------+-----------------+-----------------=|<BR />|name &nbsp; &nbsp; &nbsp; &nbsp; |id &nbsp; &nbsp; &nbsp; &nbsp; |fname &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|lname &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<BR />|=------------+-----------+-----------------+-----------------=|<BR />|{"name":"HR"}|{"id":"11"}|{"fname":"Ajay"} |{"lname":"Murthy"}|<BR />|{"name":"HR"}|{"id":"11"}|{"fname":"Ameya"}|{"lname":"Pandey"}|<BR />|{"name":"HR"}|{"id":"11"}|{"fname":"Amit"} |{"lname":"Joshi"} |<BR /><BR /><BR />I want the output rows to contain a single value and not name-value pair as shown above. How can I achieve it (without using JsonPath) by using Xpath?</P> Tue, 29 Dec 2015 11:57:53 GMT Anonymous 2015-12-29T11:57:53Z https://community.qlik.com/t5/Talend-Studio/Xpath-in-tExtractJsonFields-giving-incorrect-output/m-p/2324694#M94367 <P>Hello. I used Xpath for retrieving JsonFields as shown on the forum. However, the output is in the form of name-value pair which is not like the one shown on Talend Forum.<BR />The output is as follows:-<BR />.-------------+-----------+-----------------+------------------.<BR />| &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;tLogRow_1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<BR />|=------------+-----------+-----------------+-----------------=|<BR />|name &nbsp; &nbsp; &nbsp; &nbsp; |id &nbsp; &nbsp; &nbsp; &nbsp; |fname &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|lname &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |<BR />|=------------+-----------+-----------------+-----------------=|<BR />|{"name":"HR"}|{"id":"11"}|{"fname":"Ajay"} |{"lname":"Murthy"}|<BR />|{"name":"HR"}|{"id":"11"}|{"fname":"Ameya"}|{"lname":"Pandey"}|<BR />|{"name":"HR"}|{"id":"11"}|{"fname":"Amit"} |{"lname":"Joshi"} |<BR /><BR /><BR />I want the output rows to contain a single value and not name-value pair as shown above. How can I achieve it (without using JsonPath) by using Xpath?</P> Tue, 29 Dec 2015 11:57:53 GMT https://community.qlik.com/t5/Talend-Studio/Xpath-in-tExtractJsonFields-giving-incorrect-output/m-p/2324694#M94367 Anonymous 2015-12-29T11:57:53Z https://community.qlik.com/t5/Talend-Studio/Xpath-in-tExtractJsonFields-giving-incorrect-output/m-p/2324695#M94368 Hello! I got the desired output by deselecting the "Get Nodes" tab in tExtractJSONFields component. Since I am newbie to Talend, can anyone tell me the significance of "Get Nodes" tab? Tue, 29 Dec 2015 12:31:09 GMT https://community.qlik.com/t5/Talend-Studio/Xpath-in-tExtractJsonFields-giving-incorrect-output/m-p/2324695#M94368 Anonymous 2015-12-29T12:31:09Z