Custom Data Import

Alfred Tang
Topic Author
Offline
New Member

8 years 2 months ago #4483 by Alfred Tang

Custom Data Import was created by Alfred Tang

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) )?

Code:

{"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 to join the conversation.

Alfred Tang
Topic Author
Offline
New Member

8 years 2 months ago #4484 by Alfred Tang

Replied by Alfred Tang on topic Custom Data Import

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

Code:

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

Please Log in to join the conversation.

Daniel
Offline
Administrator

8 years 2 months ago #4485 by Daniel

Replied by Daniel on topic Custom Data Import

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 to join the conversation.