Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 ves_diego
		
			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
		
			manodwhb
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		@Diego Vescovi , if you are using enterprise you can use talend datamapper to convert complex json conversions.
Thanks,
Manohar
 ves_diego
		
			ves_diego
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you @Manohar B , but i'm using free version.
Thank you,
Diego
