Forum Discussion
Help transforming data with bizarre design-pattern
As you can see, the month name appears accross twelve columns - and this entire thing is just breaking my brain. Anybody have experience or advice for how to transform this data into something more suitable for dimensional model?
First change the column names to add "-25" to them, e.g. "Jan-25".
Then select the first three columns, go to the Transform tab and choose Unpivot Other Columns. You can then turn the attribute column into a date type, and obviously rename the columns appropriately
2 Replies
First change the column names to add "-25" to them, e.g. "Jan-25".
Then select the first three columns, go to the Transform tab and choose Unpivot Other Columns. You can then turn the attribute column into a date type, and obviously rename the columns appropriately
