How to set NULL values with MxLoader

A frequent question from people using MxLoader is how to clear the value of a field.

For example, if asset 11230 has the serial number field set to a certain value and we want to blank it out, the following MxLoader sheet will not do the job.

This is because MxLoader skips all the blank cells and does not pass the blank value to Maximo.

To achieve what we want, we can enter NULL to actually clear the value of the SERIALNUM field.

This is actually not specific to MxLoader but is a Maximo Integration Framework feature.