Six Stars

How to convert Json Array (nested) in multiple rows

Hello everybody,

 

I have a Json array that looks like this screenshot:

 

nested_array.PNG

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

Table_Output.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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

Re: How to convert Json Array (nested) in multiple rows

1 REPLY
Seven Stars

Re: How to convert Json Array (nested) in multiple rows