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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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?