Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ericdanqua
Creator
Creator

identify month name from field value

Hello,

I have a field(filename) that holds values which contain the month information (Posted in march ). I would like to derive a new month field by identifying the month value in the filename field. sample filename field values are below.

filename

posted in march

May posting

was sen in august

posted in April

 

Expected result

Month

March

May

August

April

 

Thanks

Eric

Labels (2)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Many ways could be there. One is like:

Load *,
              Month(MakeDate(1,WildMatch(Upper(filename),                   '*JAN*','*FEB*','*MAR*','*APR*','*MAY*','*JUN*','*JUL*','*AUG*','*SEP*','*OCT*','*NOV*', '*DEC*'))) as Month
Inline [
filename
posted in march
May posting
was sen in august
posted in April]

tresesco_0-1598421206180.png

 

View solution in original post

1 Reply
tresesco
MVP
MVP

Many ways could be there. One is like:

Load *,
              Month(MakeDate(1,WildMatch(Upper(filename),                   '*JAN*','*FEB*','*MAR*','*APR*','*MAY*','*JUN*','*JUL*','*AUG*','*SEP*','*OCT*','*NOV*', '*DEC*'))) as Month
Inline [
filename
posted in march
May posting
was sen in august
posted in April]

tresesco_0-1598421206180.png