You can translate the question and the replies:

Base views - Importing tables with same names

We have the following structure Databases : Year2014, Year2015, Year2016.... Tables in each YearDDDD database : abc, mno, xyz... We are able to create base views with the first YearDDDD database that we try. However we are not able to import subsequent year tables easily since they have the same name. Is there a way to add a prefix/suffix name during the import so that we can easily import tables with the same name? We have 10's of tables in each YearDDDD database and 10's of YearDDDD databases. Also is there a way to automate creation of base views?
user
06-02-2017 10:54:28 -0500

2 Answers

You can right-click on a group of views (select multiple) and there is an option to prefix those views. That may do what you need.
user
07-02-2017 14:09:38 -0500
Hi, To brief previous answer in detail, if you already have a base view created with name ‘XYZ’ and you want to import a table (‘XYZ’) within the same database in Virtual Data Port Administration tool, you can prefix the base view name that is already created by following steps: - Select multiple base views ‘xyz’,’abc’,’mno’ in the element tree. - Right click on it choose “Prefix selected views/associations “. - Enter the text to be prefixed in the dialog box that appears. You can also create base views using VQL statement “CREATE TABLE” for which you can find the syntax in section “Creating A Base View” from “[Advanced VQL Guide](https://community.denodo.com/docs/view/document/Denodo%20Express/Denodo%206.0/Advanced%20VQL%20Guide)”. If you need to automate the process of creation base views, you could create a Scheduler Job in order to execute a specified VQL statement regularly. Refer the section “Creating and Scheduling Jobs” from [Scheduler Administration Guide](https://community.denodo.com/docs/view/document/Denodo%20Express/Denodo%206.0/Scheduler%20Administration%20Guide). Hope this helps.
Denodo Team
14-02-2017 23:16:38 -0500
You must sign in to add an answer. If you do not have an account, you can register here