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

matthew_hughes
Kilo Sage

21m ago - last edited 7m ago

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:

matthew_hughes_0-1779185685006.png

 

 

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:

matthew_hughes_1-1779185758970.png

 

I'm using the below field mapping:

matthew_hughes_0-1779186811243.png

 

 

 

 

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.

 

0 Helpfuls
  • 39 Views
1 REPLY 1

Venky Kshatriy2
Tera Expert

9 seconds ago

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.

 

0 Helpfuls