Transform string array to csv mulesoft 4.1.2

Question

I have Array of Strings, want to convert it into a csv output in mule 4.1.2. Sample input payload is as below -

[ "{\n "id": 123,\n "name": "ABC",\n "communication": "email"\n}", "{\n "id": 123,\n "name": "ABC",\n "communication": "paper"\n}" ]

I need csv output with columns as

MemberId Person Name Communcation 123 ABC email

Answer 1

This is fairly simple using DataWeave

%dw 2.0
output application/csv headerLineNumber = 0 , header = true
---
payload map ( payload01 , indexOfPayload01 ) -> {
    MemberId: payload01.id as String,
    "Person Name": payload01.name,
    Communication: payload01.communication
}