Converting month to its number

Avatar

Avatar
Validate 1
Level 1
Raaghuik1996
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile

Avatar
Validate 1
Level 1
Raaghuik1996
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile
Raaghuik1996
Level 1

19-08-2020

Hi,

 

I have a column in a schema containing name of the month like Jan, Feb....etc & I want to convert the name of the month to its specific number like Jan = 01, feb=02...ect in the enrichment activity after pulling it from schema

 

Kindly help if any inbulit function will sort the issue for me

 

Regards,

Raaghu

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

19-08-2020

Hi @Raaghuik1996

create new column with this expresion:
Iif(@column='January','1' , Iif(@column='February','2' ,Iif(@column='March','3' ,Iif(@column='April','4' ,Iif(@column='May','5' ,'Other')))))

Adjust source column name and other months.

In case you have dates in some column you can use built in function for month number Month (<Date>)

Regards,

Milan

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

157 likes

Total Posts

927 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

157 likes

Total Posts

927 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

31-08-2020

Hi @Raaghuik1996 ,

 

Were you able to solve this with the given help? Do let us know.

 

Thanks!