You can translate the question and the replies:

Replaceing a view while copying previous work

Hi when you need to change a View from one type to another, for example Selection to Join View, you are forced to create a new View that replace the old one. At the same time you whant to copy all work that is done in the Output section of the first View, like renaming columns and deriving new columns etc. I don't see how this can be done in a simple way. I can create a Join View from a Selection View by adding a Join when editing the Selection View. I can Save and it seams to work, but I got the message *'The VQL of this view has been modified manually. If you change any settings outside the "Metadata" tab, the current VQL will be lost.*' When changeing the columns while editing a view works and I far I can see do not generate any warnings like above. What is the recommended steps to bring the changes you have done on the first View to the new View when replacing the first one?
user
28-04-2023 11:56:14 -0400
code

1 Answer

Hi, The message you are receiving occurs when you edit the view in the VQL tab and serves as a notification that the view was modified manually. It is recommended that you create views graphically whenever possible. To modify a Selection View into a Join View, you can go to the VQL tab and copy the VQL that creates the view and paste it into a VQL Shell. Make sure that the VQL starts with CREATE OR REPLACE VIEW and modify it to include a join. Recreating the view this way will include all the modifications you made in the existing view. Something to keep in mind with this approach is that with certain view changes, Denodo will notify what views will be affected but will not propagate the changes to other views so you will have to manually update the affected views. I would recommend that you create a backup of the view you are modifying and the views dependent on the modified view so that if any accidental errors occur you can go back to a previous version that is working properly. If you still need help and you have a valid support user account, please open a new case at the [Denodo Support](https://support.denodo.com/) site so that the support team can assist you. Hope this helps!
Denodo Team
02-05-2023 20:26:32 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here