Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
yes
Try like:
Load
Year(Date#(YeraMonth, 'MMMYYYY')) as Year,
Month(Date#(YeraMonth, 'MMMYYYY')) as Month
Edit: Added a missing 'Y' in the format
Try with this way
Noconcatenate
Load
*,
Right(YeraMonth,4) as Year
Left(YeraMonth,3) as Month
Resident Source;
Drop table Source;
Regards
Anand
Try like:
Load
Year(Date#(YeraMonth, 'MMMYYYY')) as Year,
Month(Date#(YeraMonth, 'MMMYYYY')) as Month
Edit: Added a missing 'Y' in the format
This way, Month would be a text field and we should avoid that.