Group Data by Year

Wojciech Glowacki Member

November 24 in General

Hello,

in one of my datasets I have a date column. Is there a way I can group this and count by Year only? I know I can group them by the whole date but is there a way to do it by year. Thanks!

0

Answers

• 

  Wojciech Glowacki Member

  November 24

  I know probably I can do it by first transform that data and just leave the first 4 digits, save it and then group and count, but we got some questions that people would like to do it during profiling of the table.

  0
• 

  Josh Boxer Administrator

  November 25

  You are correct that would need to add a new column using a Transform step and the Substring Function to create a Year column that can be grouped on

  

  1
• 

  Henry Simms Administrator

  November 25

  There's also a Parse Date function which could help here:

  https://community.experianaperture.io/discussion/751/parse-date

  Once the value is a "Date" datatype, you can use the Get Years function. You can Profile the resulting output in a Workflow

  2