Hi,
I am using Import CSV to Database plugin to save data from CSV to database table. However the last row of the CSV data is getting stored twice in the database table. Can anyone please let me know how to overcome the issue?
Below is the configuration of the smart service we are using:
Delimiter: ,
File Has Header: true
Column names: <no value>
Csv header names: <no value>
Discussion posts and replies are publicly visible
without file example it is hard to guess but maybe there is just additional line break that you do not see when you open file in notepad? Instead of avoiding this just query cdt in your process model to get item that is empty/duplicate and then delete it.
Need more information to suggest the exact root cause. Generally speaking it seems the csv file data issue.