Expend table to create subcategories

Lara
Lara Member

Hello,

 

How can I transform my table 1 to the format of table 2 ( as seen in the attached docment)

I am doing it with magic ETL by maping values and then replacing it the first column , but it takes a lot of time!

I hoped there would be a more efficient way of doing it.  Any suggestions?

 

Thank you!

Comments

  • Hi,
    Anyone help out with this request?

    Thanks,

  • shummer
    shummer Domo Employee

    Hey Lara,

     

    You may want to try the uncollapse columns feature in ETL. You can find more information about that here:  https://knowledge.domo.com?cid=etlactionseditcolumns

     

    The Uncollapse Columns action lets you "pivot" or de-normalize data in tables using key-value pairs, transforming a single column with multiple rows into multiple columns in a single row. 

     

    Hopefully, that's helpful!