You can translate the question and the replies:

Custom Script

How can i achieve this.. I am having couple of tables T1 with column C1, C2, and C3 T2 with column D1, D2, and D3 I need to look into a table T1 based on where condition (where C1 = 'ABC') and check if column C3 having value. - If so i need to pickup C3 value from T1 and get the matching rows from T2 and insert into T3. - If Column C3 is null skip this
user
27-09-2021 23:54:44 -0400

1 Answer

Hi, This requirement can be achieved through standard VQL. I would recommend the [Defining a Derived View](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/defining_a_derived_view/defining_a_derived_view#defining-a-derived-view) documentation for the syntax. For your scenario, the derived view would look like: ``` create view T3 as select T1.C3, T2.D1, T2.D2, T2.D3 from T1 join T2 on T1.C3=T2.D3 where T1.C1='ABC' and T1.C3 is not null ``` If you still need help and you have a valid support user account, please open a new support case at the [Denodo Support site](https://support.denodo.com/) so that the support team can assist you. Hope this helps!
Denodo Team
29-09-2021 03:29:08 -0400
You must sign in to add an answer. If you do not have an account, you can register here