Forum Discussion
Solved
Help transforming data with bizarre design-pattern
Recently I was asked to add a [task list estimates] table to our data warehouse. The structure of this data has me confused as to how to proceed. As you can see, the month name appears accr...
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
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