How to change the structure of a dataset from wide format to long format?

Hi ,

 

I am new to Domo and I have to work with a particular dataset which is sent by Avercast, an Inventory Forecasting and Demand Planning software company.

The data uploaded into Domo is in a wide format. It has seperate columns for Date fields and I want all these columns to be grouped into a single Date column.

Is it possible to do that in Domo?

 

Regards.

Prajwal

Best Answer

  • AS
    AS Coach
    Answer ✓

    Yes!  You'll want to use the "Collapse Columns" action in the ETL tool.  It works great for this purpose.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • AS
    AS Coach
    Answer ✓

    Yes!  You'll want to use the "Collapse Columns" action in the ETL tool.  It works great for this purpose.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Thanks. I will check it out.