Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert months (numeric) into text

Hi Experts

I have a file that contains months in a numeric format. How can I convert the numeric values into text for the months? (Jan, Feb, e.g.)

Thank you for your help!

Jan

11 Replies
hariprasadqv
Creator III
Creator III

Hi,

use dual function or MMM format with date.

hic
Former Employee
Former Employee

If you want your month names automatically sorted - i.e. as dual values - you should use the solution suggested by Robert_Mika:

     Month(MakeDate(2015,MonthNumber))

Month names created with Text() will be sorted alphabetically, which you don't want.

An inline table will work, but this demands an additional table, when you really want to convert month numbers to month names when loading another table, i.e. inside another Load statement.

HIC