Excel File

Question

Hi Team, 
 When using import CSV to Database smart service, is there a way to update the data after uploading the document 
 
 Eg: 
 In my excel file, I have 3 columns 
 id, name, updatedon 
 id and name values will be availble in the csv file, after uploading the file and when writing to DB we need to update the updatedon value with the updatedon time.

Mathieu Drouin · Answer

If this table needs to be available via Records, I would suggest simply selecting all the data and updating the fields via the Write Records service. 
 Otherwise, I would simply run an Update statement using the Query Database Smart Service: 
 https://docs.appian.com/suite/help/23.3/Query_Database_Smart_Service.html

Harsha Sharma · Answer

You can define an After insert trigger on the underlying table to update the updatedon value. That way updated on will be populated automatically after each row insertion in the table.

Excel File

Top Replies