Generating Query from DataTable

[MrTik]

Hello,

Is is possible to generate visualization query directly from
DataTable? My requirement is such that I have to get two separate
spreadsheets from google docs, then join them and the pivot them. The
first two steps are completed using query and data view object. I am
now wondering how to pivot the resulting data?

Any thoughts? Ideas?

Regards.

[asgallant]

There is no built in functionality for pivoting DataTables; you'll have to roll your own code for that.  Depending on the structure of your data, you may be able to pivot when you query and then aggregate the two pivoted queries.