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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tfileInputJSON and XPATH

I have a JSON file that contains
{"ORDER":"250"}

I would like to parse JSON with the use of XPATH. I use tFileIputJSON and logRow. What I have to do so that "250" will be shown with tLogRow.
I don't know what I have to put inside 'Loop Xpath query' and 'Xpath query' ?
0683p000009MEHX.png
Labels (3)
11 Replies
Anonymous
Not applicable
Author

No, you can't.

This is not true. This can be achieved with this setting:
0683p000009MEHv.png
Anonymous
Not applicable
Author

Hi,

@louislinlin 

let's assume I have data like below

{"order":{"seba":120,"saran":121,"louislinlin":100,"aaa":120,"bbb":123}}

In this case, if I create two columns, how can store all the key values into this.

and I know to loop it I have to give "/order" Loop Xpath query, what do I need to give at XPath Query