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

JSON to data converter converts dates

udeshika_sewwanudeshika_sewwan Member Posts: 9 Learner III
edited September 2019 in Help
I am reading data from a MongoDB collection using RapidMiner Studio and converted them to table format using JSON to Data operator. Given that I have a field called 'date' in ISO date format, when I convert JSON to data using the above operator that date format changes to some other format like milliseconds I guess. The problem is all the dates converted to one millisecond value '2147483647'. 

Is there a way that I can give a format of conversion or some workaround for this ? 
Tagged:

Answers

  • yyhuangyyhuang Administrator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 364 RM Data Scientist
    edited September 2019
    Hi @udeshika_sewwan,

    You can use “Numerical to Date” operator as a workaround to transform the millisecond values back to a time stamp. Do you have any example json to share for testing?

    Cheers,
    YY
Sign In or Register to comment.