Joining 2 JSON tables

[darren....@internode.on.net]

Hi All,

I am trying to join 2 json tables to display as on graph

the tables are $jsonTable & $jsonTable2.

both of these contain temperature and time entries from separate sensors and gathered at different times.

I have looked at the join example here http://code.google.com/apis/visualization/documentation/reference.html#google_visualization_data_join

but not sure on the correct formatting to adapt this to join the json

basically I want to adapt the code below to show each table on the same graph as different colours

var data = new google.visualization.DataTable(<?=$jsonTable?>);

Any help would be greatly appreciated

Darren

[Darren Macleod]

Hi Daniel,

just wondering if you could point me in the right direction on this one?

Thanks

Darren

[Daniel LaLiberte]

You're not actually joining the json, so think in terms of how the json ends up in each DataTable. 

Maybe the problem is that a join is not really what you want. The join operation is designed to merge table rows based on identical values in different columns of each table. Since both your tables have the same kind of data, then maybe what you really want is just to append one table to the other, or merge them, sorting on the time column, for example.  We don't have an append operation, though you could pretty easily iterate through the rows of one table and add them to the other.

Hope that helps.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/f7bb3b79-7816-401b-8874-ceb861b5ee8f%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Daniel LaLiberte

dlaliberte@Google.com   5CC, Cambridge MA