You can translate the question and the replies:

Appending Views

Hi I need to append views on my VDP, can we do that? Also, I have already created format views so I need to update the datasource first and then base view and then format view
user
24-01-2020 04:08:17 -0500

1 Answer

Hi, I understand that with append you mean combining the results of two views with identical schemas. This being the case I think that what you are looking for are [UNION views](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_union_views/creating_union_views). I would read the documentation linked for more information about how this type of derived view works. Regarding the second part of your question the only changes that you should worry about propagating are the changes on the actual source. In case something is changed on the schema of the underlying tables I just open the affected base views and under the Edit tab click on ‘[Source Refresh](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/source_refresh/source_refresh)’. This will take care of propagating these changes to the affected derived views if you choose to on the popup window. Hope this helps!
Denodo Team
27-01-2020 17:03:37 -0500
You must sign in to add an answer. If you do not have an account, you can register here