On using import excel to database smart service getting this error : Incorrect integer value: '' for column `Appian`.`tablename`.`palletqtyno` at row 1???

I am trying to use import excel to database smart service for importing my data from excel into appian table.

In my CDT i have columns of text and integer type. But when trying to use the excel file with integer column as blank it is throwing me error as:

Incorrect integer value: '' for column `Appian`.`testBT`.`palletqtyno` at row 1???

where testBt is my tablename and palletqtyno is my column name whose data type is defined as integer in CDT

  Discussion posts and replies are publicly visible

Parents Reply Children