Is there a way to create views in RDM that contain union statements combining queries to different tables?
Solved
UNIONS in RDM Views
- Data Enthusiast
Best answer by AKislyakov
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.
- Ataccamer
- 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.
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.