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.
Pivot & UnPivot -Single Record - TIBCO Spotfire Community
TIBCO Spotfire Community » TIBCO Spotfire » TIBCO Spotfire Clients » Pivot & UnPivot -Single Record

Pivot & UnPivot -Single Record

Last post Fri, May 4 2012 8:04 AM by jcskalant. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • Fri, May 4 2012 7:56 AM

    Pivot & UnPivot -Single Record

    Reply Contact

    Hi,

    Can't I do Pivot and Unpivot at the same time?

    I have a output like this,

    ID    Name                Value

    1      Client A             100

    1       Client A             100

    I want this in a single row.

    ID   Name    Value

    1    Client A  200 

      To make it in a single row , I can Pivot "Name" and "Value" and bring to the Visualization but then I have other columns to Unpivot too. I don't want to do Crosstable as well.

    What would be the best other approach?

    Thanks.

    Jesus answered, “I am the way and the truth and the life. No one comes to the Father except through me. John 14:6

  • Fri, May 4 2012 8:04 AM In reply to

    • jcskalant
    • Top 10 Contributor
    • Joined on Sun, Aug 21 2011
    • Panamá
    • Posts 258

    Re: Pivot & UnPivot -Single Record

    Reply Contact
    Hi John,

    Can you clarify what other columns you have in your data table?

    Can you share the entire structure of the datatable to understand the challange better?

    Cheers,

    JC

    Juan Carlos Escalante
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