Map CSV file to Structured Json

[ves_diego]

Hello everyone!

I need to map to CSV file to a JSON by changing the structure, for example:

CSV file:

And this is the JSON file:

Any suggestions?

I'm trying to use tFileInputJSON and tFileOutputJSON with the tMap but without success

Thank you

[Ravi_Rajagopal]

Please copy/paste the flow of the job. Also I would like to see the schema of the csv and json as you read the data in and I would like to see the tMap configuration as well.

[ves_diego]

thank you.

i'm changing approach using the tWriteJSONfield:

this is the csv schema:

and the json structure:

with the tWriteJSONField i created this JSON tree:

Now the output is good, but it's not the same as the main structure.

I have 2 (main) problems:

1) how can i add the array

"aspectNames": ["dcr:commonDCR"]

with tWriteJSONField ?

2) in some key, for example "dcr:caseID" i have to add the prefix "dcr:", but when i try to add it in the json tree like a "sub-element", i have this error:

"The prefix "dcr" for element "dcr:caseID" is not bound."

thank you

[ves_diego]

CSV Schema:

 

JSON Structure: 

JSON tree:

[ves_diego]

have you an idea please?