How to convert collection of documents into single json document ?

Harshav

I executed data to json operator and flatten the collection ,I got collection of documents as you can see in the below screenshot .





How to store this into one single proper json format file ?

BalazsBarany

Hi,

RapidMiner doesn't have this kind of JSON processing capabilities. 
You could put the data one by one into a JSON capable database like PostgreSQL and use the functionality built in to group the JSON documents, for example. Or one of the scripting languages supported by RapidMiner: Groovy, Python or R.

If the number of documents is not too large, you could try processing the collection with Loop Collection and add all the elements to a macro with Generate Macro.

Create Macro with "[" as the starting point, then add the elements from the connection and "," (but not for the last element), and finally close it with "]". That would result in the macro having a valid JSON array. 

Regards,
Balázs

frederic_gomer_

Hi,

We don't have a view on your process.

First use Text Processing Extension in Marketplace (https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_text)

If you're after a loop value, you can use append superset operator to make example of your object collection and connect to Data To JSON operator check generate array and finally connect to Write Document by specify youfile.json (enter a path before ex: C:\DATA\youfile.json) encoding UTF8 and check overwrite.