Currently in Domo, the Transpose option available in the Megatable card works only when the number of columns in the source dataset remains constant. However, in many real-world data scenarios, the number of columns can change between refreshes, making it difficult to reliably restructure the data using the existing functionality.
It would be extremely valuable to have a dynamic transpose capability within Magic ETL that can automatically convert columns into rows regardless of how many columns are present in the dataset at the time of refresh.
Use Case:
Some datasets contain a variable number of columns that represent similar types of data (for example, dynamically generated fields or date-based columns). When these datasets refresh, the column count may increase or decrease. A dynamic transpose function would allow these columns to be flipped into rows automatically without requiring manual updates to the ETL each time the schema changes.
Requested Enhancement:
Add a Dynamic Transpose (Unpivot All Columns) tile in Magic ETL that can automatically detect and transpose columns regardless of how many exist in the dataset at refresh time.
