Data360 Analyze

 View Only

  • 1.  PIVOT Table - Convert Rows to Columns

    Employee
    Posted 01-13-2022 14:25

    Hi 

    I always struggle and dont think I have ever found an easy way to do this in the years I have been using D360/LAE.

    Here is my data:

    serviceID,plan_instance_field,plan_instance_value
    MYRA04/WAVE/U/108039,BillingTiming,ANNIVERSARY
    MYRA04/WAVE/U/108039,BillingCoverage,ADVANCE
    MYRA04/WAVE/U/108039,BillingType,ADVANCE

    How do I get this:

    serviceID,BillingTiming,BillingCoverage,BillingType
    MYRA04/WAVE/U/108039,ANNIVERSARY,ADVANCE,ADVANCE

    I have tried everyhing and cant find an article that helps me understand it. I try many combinations on the pivot nodes and they arent easy to figure out.

    Any help appreciated.

    Thanks Martin



  • 2.  RE: PIVOT Table - Convert Rows to Columns

    Employee
    Posted 01-18-2022 04:50

    ignore this. am not thinking and sorted it now...cheers