Appending CSV file in existing table which has conflicting primary keys

[koslambrou]

Suppose I have to following table named Test in a SQLite database:

Id	Text
1
2
3
4	Four

Here's a CSV file which I want to append:

Id,Text
1,One
2,Two

I used the following command for the merge:

csvs-to-sqlite -t Test Test.csv sqlite.db

Here's the modified Test table:

Id	Text
1
2
3
4	Four
1	One
2	Two

As you can see, there are duplicate elements in the Id column (which is not a primary key)

Is there a way to get the following output ?

Id	Text
1	One
2	Two
3
4	Four

If I declared the Id column as a primary key, appending to the table produces the error sqlite3.IntegrityError: UNIQUE constraint failed: Test.Id.