Set field to empty on data import

[Susan Davidson]

We are receiving a file via email which is updating our location table.

Periodically a value needs to be updated to be empty

So say our fields were:

Name, Address 1, Address 2, City, State, Zip, Contract due, Contract renewal state

Values on day 1:

Nameis, Address  line 1, Address line 2, ACity, AState, AZip, 09/01/2024, Contract renewal

Values on day 2:

Nameis, Address  line 1, Address line 2, ACity, AState, AZip, 09/01/2024, 

The contract renewal state field is now empty and where it was valued before with "contract renewal" and that went into the u_contract_renewal field on import it should now be cleared by the source data.. it isn't. If the source field is empty then no action happens on the target and it just keeps the value from the last time the source field was valued. Is there a way for me to tell it to clear that value (that's easy)?

[AnveshKumar M]

Hi @Susan Davidson 

The other option is in field mapping change the source to script type and check if the source is empty return empty string ("") other wise return the value as source.

[AshishKM]

Hi @Susan Davidson,

There should be some Data Source defined and Transform map running on this File based upload.

Please check which Transform map is updating this source to target data, Open that transform map and check the field mapping for this "contract renewal" column. 

To re-set the target value same as source for empty value, you have to write some code to read the source value and set the target same else system will change the target.

Incase you need more help, please share the mapping details for this "Contract Renewal" field.

Please mark correct answer and helpful for others if it helps you