topic Map CSV file to Structured Json in Talend Studio

Map CSV file to Structured Json

ves_diego — Sat, 16 Nov 2024 01:14:32 GMT

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

Re: Map CSV file to Structured Json

Ravi_Rajagopal — Mon, 26 Oct 2020 22:56:18 GMT

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.

Re: Map CSV file to Structured Json

ves_diego — Tue, 27 Oct 2020 07:00:57 GMT

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

Re: Map CSV file to Structured Json

ves_diego — Tue, 27 Oct 2020 07:06:06 GMT

CSV Schema:

JSON Structure:

JSON tree:

Re: Map CSV file to Structured Json

ves_diego — Wed, 28 Oct 2020 08:26:06 GMT

have you an idea please?