Balaji Balasubramaniam 2 Posted April 11, 2019 Share Posted April 11, 2019 I connect to Impala. In Spotfire I have a query with 2 inner joins and an order by clause on the outer query. The query returns sorted data when run directly on the db but in Spotfire, the resulting data table from the query is not sorted. There is an IronPython script that runs on the sorted data table. As far as I can tell, sorting the table using Properties > Sorting only sorts the visualization and the underlying data table is still the original table. So when the script iterates through the rows, it still gets only original data and not the sorted data. Is there any way to get data into Spotfire sorted as specified in the query Is there a way in script or otherwise to sort the actual data table to match the visualization Thanks Link to comment Share on other sites More sharing options...
Tyger Guzman 2 Posted February 1, 2020 Share Posted February 1, 2020 You could try adding a Row_number() to your query as an artificial unique identifier. Or even better have your query as a view in your database and pull the view into spotfire. 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