Nested json objects with contents as array

[GabrielRodriguesS]

Scenario:

Only check "Nested Elements" option and Current Sheet Only.

Result:

Only one element was converted:

Expected:

How to fix it?

[Synthoid]

To export nested arrays you have to use specific formatting on the keys, otherwise the exported rows will keep overwriting each other. I recommend looking at the documentation for the Nested array prefix option and looking at the wiki page for nested elements in general. But just enabling the Nested array prefix option and adding the appropriate prefix to your sheet name should take care of the issue.

[mikelga]

Hi @GabrielRodriguesS I think that I have the same problem. Have you solve it?

[GabrielRodriguesS]

I put the matrix prefix and nothing. I told you how it was as soon as possible.

[GabrielRodriguesS]

Giving up, it was simpler to tweak the data using a programming language.