Automating Order of Columns
I have a column with a semi-numerical string (H.1, H.2, H.3, ...). I am performing a pivot using the column as the pivotted table's column headers. After the pivot, the columns are not sorted in natural string order. They appear like H.1, H.10, H.100, H.2, H.20, H.21, and so on. I want the columns to be organized in numeric order (H.1, H.2, H.3, ...). Is there function or feature in Spotfire that can do this? Or is there a way to do this via an IronPython script?