ao link
Affino
The Coming Interactive Web

The Coming Interactive Web 

Introducing Affino's Six AI Engines

Discover More

T74829 > How can I delete values in a column via an import?
27 Aug 2021 11:48

If you insert the following marker [_null_] into a cell, you can remove the value of the field when running these types of imports:

Using the [_null_] marker will clear out that field in the database table.

Note the following rules:

  • Action must be in Update mode
  • Value cannot be a required field (e.g. CatalogueItemID or CataloguItemName)
  • Field data type must be of type text (e.g. VARCHAR, TEXT, etc)
  • The marker does not work on number values (e.g. INT, DATE, TIME, etc.)

 

Let Us Call You Back
Contact Us
Request A Demo