Creating a JSON file from a CSV file

[rajupillai]

I have a csv file with data :

ID, Name,Age,Gender,City

10,John Doe,52,M,Austin

20,Mary Jane,42,F,New York

30,JackThomas,20,Atlanta

I like to create a JSON file that looks like 

{
"DocumentStream": [

{ "_id": "10"

   "NAME": "John Doe"

   "Age": "53"

   "Gender": M"

   "City": "Austin"

  },

{ "_id": "20"

   "NAME": "Mary Jane"

   "Age": "42"

   "Gender": "F"

   "City": "New York"

  },

{ "_id": "30"

   "NAME": "Jack Thomas"

   "Age": "20"

   "Gender": "M"

   "City": "Atlanta"

  }

 ]

}

I am pretty new Talend and been struggling with this

[DataTeam1 · Accepted solution]

Here is the solution:

JSON FILE:

[rajupillai]

Awesome DataTeam !  Can I use this to insert into my MapRDB - JSON using the tMapROJAIOutput component ?  

[DataTeam1]

I don't know @rajupillai I have never used MapRDB