transform script

[Priya123]

am having a transform script where i update approval set Date time field type on customer project table 

basically, if the import set has values other than dates leave it blank else fill it with the date

The 1st time its happening correct (like blank when no date and date when present)

but after that if i test it by making a row blank , after a date is filled , the previous value is set and not blanking. any idea?

[Peter Bodelier]

Hi @Priya123 

You'll have to check 

On the transform map.

Please note that this will be the case for all empty fields in your source.

[Priya123]

checked that option too but did not work... the values in script are coming in Right while settign the value is nt happening and retaining the old value

[Peter Bodelier]

In that case, please share your script. Without it, I cannot help you further.

[Ankur Bawiskar]

@Priya123 

please share screenshots of field map script or transform script