Mapping CSV file to JSON

[ves_diego]

Hello everyone!

I have to map to a CSV file to a JSON changing the structure, but i have some problems. This is the CSV schema:

this is the JSON structure:

I'm trying to use the tWriteJSONField:

With this JSON tree:

This is the first output:

And i have two problems:

1) i don't know how to add the array "aspectNames": ["dcr:commonDCR"] ;

2) the properties elements in the original json have the ".dcr" prefix, like "dcr:caseID", but if i put that prefix in the JSON tree, i have this error:

"[Fatal Error] :1:134: The prefix "dcr" for element "dcr:caseID" is not bound."

Please help me!

Thank you,

Diego

[manodwhb]

@Diego Vescovi​ , if you are using enterprise you can use talend datamapper to convert complex json conversions.

Thanks,

Manohar

[ves_diego]

Thank you @Manohar B​ , but i'm using free version.

Thank you,

Diego