Thanks for the tip. I've successfully joined 2 tables, but I need to
join a third. I've tried creating a join, then joining that table
with a third, but it is not working. Here is my code. Any tips would
be appreciated!
var joined_dt = google.visualization.data.join(data1, data2,
'full', [[1,1],[2,2],[5,5],[6,6],[7,7],[8,8]], []);
var joined_dt2 = google.visualization.data.join(joined_dt,
data3, 'full', [[1,1],[2,2],[5,5],[6,6],[7,7],[8,8]], []);
The problem seems to be coming from the 2nd line because if I comment
it out, my script runs fine.
On Feb 4, 2:58 am, ChartMan <[email protected]> wrote:
> you cannot specify that in a single query but you can issue two queries and
> then join the results in the client.
>
> ChartMan
>
> On Wed, Feb 3, 2010 at 11:21 PM, Narin <[email protected]> wrote:
> > Hello!
>
> > I'm building bar charts and data tables using a Google spreadsheet
> > that has multiple worksheets.
>
> > Is it possible to query data between multiple sheets that have the
> > same columns? For example, a query that shows rows 1 and 2 of Sheet
> > 1, and rows 4 and 5 of Sheet 2?
>
> > Thanks in advance for any help!
>
> > -Narin
>
> > --
> > 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.
--
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.
