Hi,
I am importing the CSV file to Database properly but when i import the same CSV file with updated value, it doesn't override the existing records.
I want to override the existing records while Importing the CSV file.
Kindly help me out with this.
Discussion posts and replies are publicly visible
Hi suryanshuj0001
You can try some trigger configured with that table insertion. Otherwise have a stored procedure to truncate the table before insertion. This could help you.
The OOTB import smart services do not support refreshing existing data.
you can truncate the table first and then insert the data to DB. for truncate you can use query database smart service. if you dont want to truncate the entire table then first you have to get the records which you have to delete via queryEntity and then use deletefromDatastoreEntity and then insert the data into DB.
As suggested by Deepak gupta you can truncate the table each time before or after the data load.
I would recommendation to truncate the table via stored procedure. You can execute the stored proc from Appain PM smart service or via a function call to executestoredprocedure(), it would be much easier way to deal with this kind of scenarios.