How to convert Json Array (nested) in multiple rows

[CimtChris]

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

[Chirgal · Accepted solution]

Use tFileInputJson
https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/_FLAj764Hj9UMDUhCE5rew