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.
Is anyone able to help out with this request?
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.