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