Extracting Month Name from coloumn name in Qlikview

[skzwane01]

Hi,

I currently have the columns below:

"Base Plan Contribution Jan",
"Base Plan Contribution Feb",
"Base Plan Contribution Mar",
"Base Plan Contribution Apr"

on so on until December.

I want to extract the Date/Month name from  the column name  and create a date  field from that column name example: "Base Plan Contribution Jan" will have a date of 01 Jan and so so . How do I go about doing that ?

Thank you in advance.

[trdandamudi]

Please use the below code and you will get the desired output:

Data:
LOAD
Plan,
01 &' ' &Right(Plan,3) as Month;

Load * Inline [
Plan
Base Plan Contribution Jan
Base Plan Contribution Feb
Base Plan Contribution Mar
Base Plan Contribution Apr
];