When using import CSV to Database smart service, is there a way to update the data after uploading the document
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.
Discussion posts and replies are publicly visible
Hello Purvaraj, You can try using the additional columns and additional values of the import CSV to Database smart service to achieve the above requirement.
Have a look into this link for more info: https://community.appian.com/b/appmarket/posts/excel-tools#
How do we pass the values to the additional columns and additional values?
Can you provide an example?
© 2024 Appian. All rights reserved.