Concat and str to date

Discussions Source to Target
1

Hi,
I’m loading date from a source. One field called year and another Month. Is it possible to create a date like a concat (year,‘-’,month,‘-1’) in the final data base?

thanks

2

Hi @ecabanas, yes you can do this in the Schema tab, there is an option to create a custom expression as a field. If you can share the Source and Target you are using, I can help further with some screenshots, etc.