Thank you very much Viz-Kid. I got it working. 2nd Question. Can I now query for another table and then join it to the first joined table?
On Mar 19, 10:16 am, Pegasusrjf <[email protected]> wrote: > I think I get it now. > > So if I want column 0 of table one to match again column 1 of table > two it would be as follows: > > [[0],[1]] > > On Mar 19, 10:09 am, Viz Kid <[email protected]> wrote: > > > > > Hi. > > > First, you should probably remove the () in the last line where you set the > > on load callback. > > Second, as specified in the > > documentation<http://code.google.com/apis/visualization/documentation/reference.htm...>of > > the join method, the fourth parameter should be an array of pairs of > > columns indices to compare. Therefore, I assume you must have meant to use > > [[0,1]] and not [0,1]. > > > Hope this helps, > > Viz Kid > > > On Fri, Mar 19, 2010 at 3:36 AM, Pegasusrjf <[email protected]> wrote: > > > Hello. > > > > No-one has any ideas here? > > > > On Mar 17, 9:13 pm, Pegasusrjf <[email protected]> wrote: > > > > I am using the code below to try an join two DataTables together. > > > > > I keep getting this error: Error: Invalid column index undefined. > > > > Should be an integer in the range [0-13]. > > > > > The first table referenced has 14 columns, and the second table has 3 > > > > columns. No matter what I try I can't get it to display the data. > > > > > I am lost as I can enter commands in the debugger and see that the > > > > data does exist for different columns. > > > > > Any help is greatly appreciated. > > > > > Code below... > > > > > <script type="text/javascript"> > > > > var visualization; > > > > var mDriverName; > > > > var mResultDetails; > > > > var mDataJoin; > > > > > function drvDataVisualization() { > > > > var qDrvName = new > > > google.visualization.Query('http:// > > > > spreadsheets.google.com/pub? > > > > key=tFijkSiJElqcqvWczlkYGfA&headers=1&gid=1'); > > > > // Apply query language. > > > > qDrvName.setQuery('SELECT *'); > > > > // Send the query with a callback function. > > > > qDrvName.send(drvDataResponse); > > > > } > > > > > function drvDataResponse(response) { > > > > if (response.isError()) { > > > > alert('Error in query: ' + > > > response.getMessage() + ' ' + > > > > response.getDetailedMessage()); > > > > return; > > > > } > > > > mDriverName = response.getDataTable(); > > > > > var qRdetails = new > > > google.visualization.Query('http:// > > > > spreadsheets.google.com/pub? > > > > key=tFijkSiJElqcqvWczlkYGfA&headers=1&gid=5'); > > > > // Apply query language. > > > > qRdetails.setQuery('SELECT *'); > > > > // Send the query with a callback function. > > > > qRdetails.send(rDetailQueryResponse); > > > > } > > > > > function rDetailQueryResponse(response) { > > > > if (response.isError()) { > > > > alert('Error in query: ' + > > > response.getMessage() + ' ' + > > > > response.getDetailedMessage()); > > > > return; > > > > } > > > > mResultDetails = response.getDataTable(); > > > > > mDataJoin = new > > > > google.visualization.data.join(mResultDetails,mDriverName,'inner', > > > > [1,0],[2,5,6,7,8],[1]); > > > > var mDrawData = new > > > > google.visualization.Table(document.getElementById('dvrDetails')); > > > > mDrawData.Draw(mDataJoin,null); > > > > } > > > > > google.setOnLoadCallback(drvDataVisualization()); > > > > </script> > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Google Visualization API" group. > > > To post to this group, send email to > > > [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<google-visualization- > > > api%[email protected]> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/google-visualization-api?hl=en.-Hide quoted > > >text - > > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
