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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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