How can one create a view in the TDM GUI where a parent column is used twice, each with a unique alias. SQL-wise, this would look like
CREATE VIEW FUTILE(X1,X2) AS SELECT DUMMY, DUMMY FROM DUAL;
The current GUI seems to only allow one copy of a column to be used for a query.
Unfortunately, it is not possible for now. However, we will deal with it for any of future TDM releases.
At the moment you can have the view only as a text:
- Edit the view and on tab General, select the “SELECT in Views as Text” checkbox.
- On tab SQL write “AS SELECT DUMMY, DUMMY FROM DUAL”.
If you have more questions, please write us back.
Regards, Vladka + TDM Team