Forum Discussion

rmcgrath's avatar
rmcgrath
Advocate II
1 year ago
Solved

Date Table?

I have a monster table I am trying to apply Star Schema to and the table contains a large number of dates.  I deal with animals, so for example there are dates for molting, dates for being placed int...
  • Ashish_Mathur's avatar
    1 year ago

    Hi,

    May be you should select all columns other than the Date columns and then select "Unpivot Other Columns".  Now you will get all dates in a single column called Value.