topic Re: Mapping CSV file to JSON in Talend Studio

Mapping CSV file to JSON

ves_diego — Sat, 16 Nov 2024 01:12:49 GMT

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

Re: Mapping CSV file to JSON

manodwhb — Thu, 29 Oct 2020 06:58:55 GMT

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

Thanks,

Manohar

Re: Mapping CSV file to JSON

ves_diego — Thu, 29 Oct 2020 08:00:53 GMT

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

Thank you,

Diego