Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
CSV Schema:
JSON Structure:
JSON tree:
have you an idea please?