Transform map field value updates need restricting

[thrsdy1512]

Hi, I have some issues with a transform map I have created. The transform is being used to update existing records in a table with new data.

1. It lets me update fields with invalid values, eg if a field has a choice list, the transform will add my invalid data value to the choice list and input it to the field. I need there to be some sort of validation checks so that if the data value is NOT a valid choice for that field, it aborts the transform.

2. Where a record does not exist in the table, the transform is creating a new record. I want it to check if there is an existing record, if there is then continue with the update. If the record doesnt exist it should NOT create one.

[Ankur Bawiskar]

@thrsdy1512 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[AbinC]

Hi @thrsdy1512 ,

Did you go through the solution i provided?

If yes please do mark it as helpful and accept as solution 

Thanks,

Abin 

[Chavan AP]

@thrsdy1512 -

Refer below, I’m sure it will help. 

1- to validate the choices you can use-  Choice Action to "Reject"  and field level source script as below:

// Sample Field Map Source Script
answer = (function transformEntry(source) {
    var sourceValue = source.getValue('your_source_field');
    var validChoices = ["choice1", "choice2", "choice3"]; // Your valid choices
    
    if (validChoices.indexOf(sourceValue.toLowerCase()) != -1) {
        return sourceValue;
    } else {
        return '';
    }
})(source);

2- and you have to prevent a new record cration so , Use onBefore Transform Script with action validation:

// Sample onBefore Transform Script
(function runTransformScript(source, map, log, target) {
    if (action == 'insert') {
        ignore = true; // Skip new record creation
    }
})(source, map, log, target);

 Pro Tip: Always set choice action to "ignore" for reference and choice columns unless necessary to prevent foreign records from being created.