As a transitional step, this site will temporarily be made Read-Only from July 8th until the new community launch. During this time, you can still search and read articles and discussions.

While the community is read-only, if you have questions or issues requiring TIBCO review/response, please access the new TIBCO Community and select "Ask A Question."

You will need to register or log in or register to engage in the new community.

Spotfire Data Table Sort

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

(1) Answer