Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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