Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Feb 10, 2016

Transpose whole data in the Data Table

No description provided
  • Attach files
  • Guest
    Reply
    |
    Apr 3, 2019

    Even with the new data wrangling (tested with 10.2) you cannot get to a good result. I tried to unpivot, then calculate a new column using RowID() and ranked it over each ex-row-header. Then did the pivot over the ranks, but then the new columns are not sorted numerically, but as a text, so 1,10,100,1000,1001...

    So a real Transpose is still needed.