topic Re: Creating a JSON file from a CSV file in Talend Studio

Creating a JSON file from a CSV file

rajupillai — Sat, 16 Nov 2024 06:21:25 GMT

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 — Tue, 12 Mar 2019 20:33:55 GMT

Here is the solution:

JSON FILE:

rajupillai — Tue, 12 Mar 2019 20:36:52 GMT

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

DataTeam1 — Tue, 12 Mar 2019 21:04:52 GMT

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