How to convert Json Array (nested) in multiple rows

Anonymous — Wed, 15 Nov 2017 15:11:24 GMT

Hello everybody,

I have a Json array that looks like this screenshot:

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

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

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

Anonymous — Wed, 15 Nov 2017 16:34:41 GMT