Options

Data to JSON , Date conversion?

sghamsgham Member Posts: 1 Newbie
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?

Answers

  • Options
    jwpfaujwpfau Employee, Member Posts: 303 RM Engineering
    Hi,

    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
Sign In or Register to comment.