Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];