Hi,
I tried importing multiple tables with a similar naming format from the SQL Server data source and faced the error stating that *“The tables below were not imported because there are existing views with the same name”*.
Virtual Dataport allows us to select charsets for the entire Server and also, for the database. I realized that by default, the server/database is in the Restricted mode, because of which the name of the base view should start with ‘a to z’ or with the Unicode characters with the code point from 200 to 377. For e.g., if you still try to import a table with a name violating this, it would assign a relevant name in the compatible format.
For importing the tables with the name as it is, Under the Administration → Database management → Edit → Identifiers charset, I chose ‘Unicode’ for the virtual database that I want to import my view into. Now, I was able to import tables with a name starting with the number.
For your scenario, That’s why 20190208TransAutoDebetDetailBCK1 is getting renamed as TransAutoDebetDetailBCK1_0.
So, you can either drop the existing base views and import them again or rename the base views in the right panel. Also, You can choose Unicode as the charset, you can import the tables with the names as expected.
For more information, you can refer to [Identifiers charset](https://community.denodo.com/docs/html/browse/latest/vdp/administration/server_administration_-_configuring_the_server/identifiers_charset/identifiers_charset#identifiers-charset) section of the Virtual Dataport Administration Guide.
Hope this helps!
