Converting month to its number | Community
Skip to main content
R
Raaghuik1996
Level 2
August 19, 2020
Solved

Converting month to its number

  • August 19, 2020
  • 2 replies
  • 1883 views

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

Best answer by Milan_Vucetic

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

2 replies

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
August 19, 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

    R
    Raaghuik1996Author
    Level 2
    September 24, 2020
    it works Thanks!!
    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    August 31, 2020

    Hi @raaghuik1996 ,

     

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

     

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...