Tim McCune 3 Posted June 12, 2019 Share Posted June 12, 2019 I know it's possible to run sql queries on external data connections but I haven't found any documentation for using sql with an embedded table so I'm guessing it's not available but I thought I'd check here first before ruling it out. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted June 19, 2019 Share Posted June 19, 2019 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 More sharing options...
Tim McCune 3 Posted June 20, 2019 Author Share Posted June 20, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now