JSON to data converter converts dates

udeshika_sewwanudeshika_sewwan Member Posts: 9 Contributor I
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 Certified Analyst, RapidMiner Certified Expert, Member Posts: 363 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
    varunm1Tghadiallyarjun_gopaludeshika_sewwan
Sign In or Register to comment.