Import CSV to Database

Question

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.

meenakshi.velmurugan · Answer

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.

Abhay Dalsaniya · Answer

As suggested by Deepak gupta y ou 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.