Is there a way to create views in RDM that contain union statements combining queries to different tables?
Best answer by AKislyakov
View original
- Ataccamer
- 79 replies
-
2 May 2024
- Answer
Hi
In RDM you can create a Data set. Data sets allow you to use an arbitrary select query to fetch its data including a union statement.
Please note, however, that unlike RDM Views, RDM datasets are read-only. Therefore, you won’t be able to change data in the underlying tables using them.
You can find sample data sets in the RDM Banking Example project.
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.