Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ves_diego
Contributor
Contributor

Mapping CSV file to JSON

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:0693p00000AFnpZAAT.png

this is the JSON structure:

0693p00000AFnpeAAD.png

I'm trying to use the tWriteJSONField:

0693p00000AFnpoAAD.png

With this JSON tree:

0693p00000AFnptAAD.png

This is the first output:

0693p00000AFnqNAAT.png

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

Labels (5)
2 Replies
manodwhb
Champion II
Champion II

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

 

Thanks,

Manohar

ves_diego
Contributor
Contributor
Author

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

 

Thank you,

Diego