Array to FlatFile

[ruchitvijay]

I have the following json:
[
{
“name”: [
“John”,
“Rick”,
“Martha”
],
“city”: [
“New york”,
“Washington”,
“Delhi”
],
“gender”: [
“Male”,
“Male”,
“Female”
]
}
]

Need to write this into csv but csv formatter needs the data to be flattened.
How can i do this.

[RogerSramkoski]

Hello,

Have you already review the existing Community topics below? Our developers replied in each of these with sample pipelines demonstrating how to flatten arrays.

• Flattening multiple array entities in JSON Object - #4 by ptaylor
• Flattening and Mapping Complex JSON - #9 by tstack