Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Transformation for this table type

Hi,  I have a question. How would I be able to use this kind of tables to transform? I want to do a combination and make sure once i choose a metric, i can then transform to a chart easily. ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Anonymous 

    you can do the same say

     

    then you can split the column to get year and month

     

    pls see the attachment below

ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

Anonymous 

select first column and unpivot other columns

you should get below output

pls see the attachment below

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ryan_mayu ,

I am able to do it if my Jan - April column does not include date.

But when i include date like Jan 2023, it does not work already.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    could you pls sample data and what's the expected output? Since I didn't see year info in the screenshot you provided.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi ryan_maju,

      Sorry, i change my sample to add in the year as i left out previously..

      This is the sample and I am trying to get something similar to you. However, when i unpivot and do the same, it does not align well.

      After I unpivot Other Columns i will recieve something like this 

       

       

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        3 years ago

        Anonymous 

        you can do the same say

         

        then you can split the column to get year and month

         

        pls see the attachment below