Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Xpath in tExtractJsonFields giving incorrect output

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.
The output is as follows:-
.-------------+-----------+-----------------+------------------.
|                          tLogRow_1                           |
|=------------+-----------+-----------------+-----------------=|
|name         |id         |fname            |lname             |
|=------------+-----------+-----------------+-----------------=|
|{"name":"HR"}|{"id":"11"}|{"fname":"Ajay"} |{"lname":"Murthy"}|
|{"name":"HR"}|{"id":"11"}|{"fname":"Ameya"}|{"lname":"Pandey"}|
|{"name":"HR"}|{"id":"11"}|{"fname":"Amit"} |{"lname":"Joshi"} |


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?

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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?