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.

Tagged:

Comments

  • Chronos
    Chronos βšͺ️

    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.Β