Spotfire Data Table Sort

[Balaji Balasubramaniam 2]

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

[Tyger Guzman 2]

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.