Excel month column displaying date after importing into framework manager

[saumil287]

I am having an excel file which is having column month but after importing into the framework manager,It displays the entire date
I want only month name to be displayed.
Any suggestion is appreciated.

[blom0344]

Your Excel file is probably storing the column as a date, but presenting the contents as the monthname. In FM the excel formatting is omitted, hence the entire date.
You can either add a calculated column to the excel worksheet or add a query item to the FM model:

Code Select Expand


CASE
EXTRACT(MONTH,[IMPORTEDDATE])
WHEN 1 THEN 'January'
WHEN 2 THEN 'February'
....
....
WHEN 12 THEN 'December'
ELSE NULL
END