It would seem like it can’t be done automatically with the available tools. Rather than that, you will need to create an empty shell for your JSON and then loop over your data and add it.
If the source Excel file looks exactly as the one above, then you could leave what you have already to generate the initial JSON, which contains three array elements, and then adapt it.
To adapt it, you could do this:
- Loop over the JArray elements and for each occurrence of the these values , add them to the nested JArray of the first JArray element
This can be done with an Invoke Method activity and an Add method
- Either transfer the first JArray element to a new separate JArray or remove the other two main JArray elements.
I hope it makes sense to you. Feel free to ask if it is not clear enough.