Question 247342 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Convert CSV to JSON using Talend Open Studio for Data Integration

I have the below CSV file format:

title studentName studentID
Science ‘James’,’Jones’ ‘JA002′,’JO101’

I want to convert this to the below JSON format:

[{
"title": "Science",
"students":[
{
"studentname":"John",
"studentid":"JO12"
},
{
"studentname":"James",
"studentid":"JA23"
}
]
}]

How can I split the studentname and studentid in the CSV and convert it to the above JSON format using Talend Open Studio for Data Integration?

Tags:

2

Answers


  1. 0

    If there is no transformation needed, you should just be able to do the following:

    tFileInputDelimited --> tFileOutputJSON

    If there is some transformation needed, you might want to do the following:

    tFileInputDelimited --> tWriteJSONField
    Login or Signup to reply.
  2. 0

    You have 2 problems to solve here :
    First, splitting data so that Nth elements of your lists studentNames and studentIds match :
    You can do this with tNormalize and tMap :
    enter image description here

    1. Just split on the comma in your studentNames field. If you have 2 studentNames, it will create 2 rows in output (vs 1 in input)
      2)Then it is a bit more tricky in tMap, you can use split method to create an array string, and access the Nth element in "studentId" list for each name
      enter image description here

    Then you’ll have to build the JSON in output, which is quite difficult with tWriteJsonFields component I think (it is doable but I don’t like very much this component). You have 2 nested arrays, that could be quite a hassle to build with tWriteJson.

    I did it with a tJavaFlex , placed right after tMap, and JSONArray/JSONObject objects.
    enter image description here
    Don’t forget to import classes in advanced settings of tjavaflex

    import net.minidev.json.JSONObject;
import net.minidev.json.JSONArray;
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search