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.
![](https://bportaluri.com/wp-content/uploads/2020/04/mxloader-blank-512x103.png)
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.
![](https://bportaluri.com/wp-content/uploads/2020/04/mxloader-null-512x103.png)
This is actually not specific to MxLoader but is a Maximo Integration Framework feature.
How to set NULL values with MxLoader
Great explanation Thanks!
Can i download MxLoader old Version?
because i used to old Maximo
How to remove a value with date type? This method doesn’t seem to work if trying to nullify a date-time field. MxLoader will throw “Type mismatch” error.
How to set empty in a date type field?
It’s not clear to me that date and numeric fields are supported yet, from this page:
https://www.ibm.com/support/pages/setting-field-values-null-interface-tables-or-flat-files-data-sources
Does anyone know if there is some way MxLoader can null them?