Jump to content

Is it possible to run sql queries on an embedded table


Tim McCune 3

Recommended Posts

Data needs to be first imported in Spotfire datatable then this data table can be set aslinked to source or embedded.

If data table is embedded, that means it will always use data present in the analysis and would not be pulling it from database or information link. If you want to refresh the embedded data in data table, you can reload all data in that dxp which will refresh embedded data as well.

Link to comment
Share on other sites

I would like to be able to use sql queries to modify the embedded data.  For instance, to join two tables or delete rows or insert columns, any of the normal sql operations.  I have a large automation task to finish and if I could run sql queries from python that would help me finish this task much more quickly.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...