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 🔵
    Accepted Answer

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

Answers