setting a value using transform script

[KeithM1]

I'm importing some department data and there is a custom field called Active.  It is a checkbox.  The data coming from the source shows either Active or Inactive.  If the status is Active, I need the custom field to be checked.  If it is Inactive, I need it to be unchecked.  I've created an onAfter transform script but it isn't setting the value after the import.  Here's the script I'm using:

    if (source.u_status == "Active"){

        gs.info("Source status: " + source.u_status);

        target.u_active="true";

        gs.info("End active if");

    } else if (source.u_status == "Inactive"){

        gs.info("Source status: " + source.u_status);

        target.u_active = "false";

        gs.info("End active if");

    }

When I look in the logs, it gets the value correctly from the source, it just isn't setting the target value.  I'm not sure what I'm missing.  I'm open to suggestions.

[KeithM1]

I hadn't thought about doing it that way.  It worked perfect.  Thank you!!

[Rajesh Chopade1]

Hi @KeithM1 

Replace target.u_active = "true"; with target.u_active = true; (and similarly for "false" to false). This ensures that you are assigning a boolean value instead of a string.

Thank you

Rajesh