The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Transpose - TIBCO Spotfire Community

Transpose

Last post Mon, Mar 28 2011 2:24 PM by rajul01. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • Fri, Aug 6 2010 10:39 AM

    Transpose

    Hi,

    in Excel you can easily transpose a dataset by copying and paste/transpose it.

    In Spotfire it works like this:

    Add Data Table (from Clipboard)

    Add an Unpivot data transformation and the directly add another Pivot data transformation, that's it.

     

    Example:

    For a dataset like this,

    Person,test1,test2,test3
    a,29,61,331
    b,26,81,842
    c,13,56,203
    d,5,42,292
    e,33,30,459

     

    you will need to do the following:

    1. Select File > Add Data Tables...
        Source data loaded from clipboard.
        Add the transformations:
            a. Unpivot
                Add columns to pass through:
                    Person
                Add columns to transform:
                    test1
                    test2
                    test3
                Category column name: Category
                Select category column data type: String
                Value column name: Value
                Select value column data type: Integer
                Select 'Include null values'
            b. Pivot
                Choose row identifiers:
                    Category
                Choose value columns and aggregation methods:
                    Sum(Value)
                Choose column titles:
                    Person
                Column naming pattern: %C
     

     Christof

    -----------------------------------
    Dr. Christof Gaenzler
    Sr Solutions Consultant
    TIBCO Spotfire
    Filed under:
  • Mon, Mar 28 2011 2:24 PM In reply to

    • rajul01
    • Not Ranked
    • Joined on Mon, Mar 28 2011
    • California
    • Posts 1

    Re: Transpose

    Hi Christof,

    What about the case in which you have a vizualization linked to a dynamic dataset, and the dataset may continue to have columns added to it over time?  Building on your example above, perhaps next week test4 is added to the dataset, and then the following week test5 is added.  Is there a way to avoid having to go in and reprogram the unpivot step to include the new columns each time a new column is added?

    Thank you,


    Rajul

Page 1 of 1 (2 items)
┬ęCopyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center