Map empty/null Date and Time using ValueMapper

Hi,

I would like to map empty values of Date and Time to another value (for example, current date and time) using ValueMapper.

Is there a way to do so?

Thanks.

Find more posts tagged with

Magic ETL

Is anyone able to help out with this request?

Hi,

I don't think value mapper has the ability to use inline function only static values for replacing.

Anyhow you can achieve that later (If it suites you) in a Beast Mode or a MySql DataFlow with the following:

IFNULL(your_date_field, CurDate())

Hope this helps.