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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ryan_mayu,

 

I tried to Unpivot but it does not look like i can use this format

 

Thanks,

Ricky

 

  • 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.