How to clear out the value on a form via a transform map

[matthew_hughes]

In my instance, I'm wanting to clear out the value of the 'IBP Tier' field of the below Application Service (cmdb_ci_service_discovered) record:

However, I only want users to be able to do this if they enter 'Null', 'NULL' or 'null' in the spreadsheet of the transform map as seen below:

I'm using the below field mapping:

However, when I run my transform, I find that it's not clearing out the 'IBP Tier' field. I was just wondering if anywhere knows what I need to do to clear the 'IBP Tier' field out.

[Venky Kshatriy2]

Hi @matthew_hughes  In the filed map script, if you select the 'reject' option, it will stop processing the entire row. change option to ignore. if choice is their it will take or it won't take

• Create: If the imported value doesn't exist, the system automatically adds it as a new option in your choice list.
• Ignore: If the imported value doesn't exist, the system skips updating that specific field but processes the rest of the row. No new choices are added.
• Reject: If the imported value doesn't match an existing option, the system stops and skips the entire record (row) to prevent bad data from being loaded.

If my response is correct, please accept the solution so it can assist others as well.

[matthew_hughes]

Hi @Venky Kshatriy2 I've done the following:

However, when I go to my import set, it shows the following results:

But when I go back to the Application Service record itself, I can see that the IBP Tier field still hasn't been cleared out:

[Venky Kshatriy2]

Hi @matthew_hughes  pls check IBP tier  filed Default Value

[matthew_hughes]

Hi @Venky Kshatriy2  There isn't a default value, but the following: