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 1 year ago in reply to Stefano

    I dont think you're going to be able to get the old value at that point. Maybe you should allow the mapping and check the values of your column after the sync by using a template on the column. Using templates will allow you to work with the current and the old value of the column.

Children