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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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