Extracting year from Date field

More
12 years 4 months ago #2811 by Mike
Help me please

I have a date field that I would like to transform or split it into 2 other fields

The source would be a field called [Date]
and the targets would be [Year] and [Month]

I currently do this manually in Excel with the functions YEAR and MONTH, can I accomplish the transformation in Adv ETL?

Sincerely,

Mike

Please Log in or Create an account to join the conversation.

More
12 years 4 months ago #2812 by admin
Use splitter transformation function

set format to delimited
and delimiter to /

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.