Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Custom Data Import

More
2 months 4 weeks ago #4485

Yes it won't work with vData as in the json format the date is available in the index name itself not in data source.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 4 weeks ago #4484

There was a typo sorry, the correct JSON file should be:

{"index":{"2017-01-01":98.7,"2017-01-02":90.5,"2017-01-03":99.64}}

Please Log in or Create an account to join the conversation.

  • Alfred Tang
  • Alfred Tang's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
2 months 4 weeks ago #4483

Hi Team,

I am trying to import below JSON data, is there any way to import each "date" and score in this data structure with DB table have built already only 2 columns ( Date (date format), Score (Float format) )?

{"index":{"2017-01-01":98.7,"2017-01-02":90.5,"2017-01-03":99.64}

Seems I can only load "date" as the data source but not a column in vData. Please help.

Please Log in or Create an account to join the conversation.