Is it possible to update a value to NULL using GRLoader?

Document ID : KB000052188
Last Modified Date : 14/02/2018
Show Technical Document Details

It is possible to update a value to null using Grloader. This is done by setting the update_if_null option to true.

Please see the following example:

<location lookup="" update_if_null="true"> </location>  

Going forward with 21.1 PES the same can be set using the keyword" EMPTY"

<location>EMPTY</location>  

The keyword can be changed by creating a configuration file.