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
Yes now the code is working....But i have one doubt, as I got the output but how to write this into database ?
Great! If you are utilizing this new rule within a process model, you will save the output into a process variable of type Brexit_shipment_tracker (multiple), then persist to the database utilizing the Write to Data Store Entity smart service. Note you can also write the data within a SAIL form using a!writeToDataStoreEntity().
Thanks Chris