topic Re: How to "embed" csv file in json in Talend Studio

How to "embed" csv file in json

Anonymous — Tue, 08 Apr 2014 15:56:50 GMT

Hi all,
i have a csv like this :
Id,name,lastname,trainingCode,trainingCost
1,Simon,Tod,AX2,2345
I need a json output like this :
Employee : {
"id" : 1,
"name" : "Simon" ,
"lastname" : "Tod",
"training" : {
"trainingCode" : "AX2",
"trainingCost" : 2345
}
}

How can i do it?
tyvm
Simone

Re: How to "embed" csv file in json

Anonymous — Wed, 09 Apr 2014 06:44:14 GMT

Hi Simon,
Check the screenshot for further details....
Thanks
Vaibhav

Re: How to "embed" csv file in json

Anonymous — Tue, 15 Apr 2014 03:29:59 GMT

If you already has value like this: "{"employee":{"id":"1","name":"Simon","lastname":"Tod","training":{"trainingCode":"AX2","trainingCost":"2345"}}}" ,after tWriteJSONField component,connect a tFileOutPutDelimited component(don't connect tFileOutputJSON component after tWriteJOSNField),then you can get your expect json file.