The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Data to JSON , Date conversion?
Learner I
I want to read data from a MongoDB collection using RapidMiner Studio and will be giving a criteria (a json format) to the Read Mongo DB operator. To do this, I need a datapoint stored in a dataset and converted it to table format using Data to JSON operator. Given that I have a field called 'Date' in ISO date format, when I convert Data to JSON using the above operator that date format changes to some other format like milliseconds I guess. However I need it to perform my search in the MongoDB in its original format. What to do?
Tagged:
0
Answers
you could i.e. add a Date to Nominal operator with a
yyyy-MM-dd'T'HH:mm:ss'Z'format before the Data to JSON operator to create the ISO 8601 date format.Greetings,
Jonas