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

How to convert Json Array (nested) in multiple rows

Hello everybody,

 

I have a Json array that looks like this screenshot:

 

0683p000009Lrlr.png

Now I want to convert this array into a table format like this:

0683p000009Lrw8.png

Currently I'm working with tExtractJSONFields. But I only find a way to target one of the nested array at the same time.

My expression: "['book'][0].['category']"

                         "['book'][0].['author']" 

                         ......

So I got the Ouput for the first row. But I don't want to do the same for 50, 100 etc. rows.

 

Does anybody know a way to solve that?

 

best regards,
Christian

 

Labels (1)
1 Solution

Accepted Solutions
1 Reply
Anonymous
Not applicable
Author