NULL in mapping condition

During a mapping to ADSAccount I need to check if a field is polulated or is still NULL (Left.EmployeeID).

In the mapping condition I can't find a way to check the NULL value. Left.EmployeeID = '' does not work. Left.EmployeeID is NULL is not accepted.

There is a way to check that condition?

Thanks.

Parents Reply
  • Former Member
    0 Former Member over 2 years ago in reply to Stefano

    Hi, Stefano, could you please explain your use case? After the sync the best way to check these values is either with a template on the column or a table script. You can obtain the old value of a column using the, ie,  $EmployeeID[o]$ notation.

Children