You can translate the question and the replies:

Execution output as input of another view

Hi guys! Is it possible to use the output of an interface/dv as input for another one? I want to avoid joining them, just want to use the output of the first one to filter the second one. We want just to use two views/interfaces like in a workflow instead of joining them. We want to avoid joining. Is that possible? Thanks in advance! Best, Fabian
user
08-08-2017 10:31:10 -0400

3 Answers

Hi, I have been able to use the output of a view (base view, interface, derived view) as an input for another view by specifying the view in a where condition of another view. For instance, you could use the below query, to get the result of view2 based on the results of view1. ``` Select * From view2 Where field12 in (Select field11 From view1) ``` In Virtual DataPort Administration tool, you could create this query graphically by specifying the Where condition using ‘in’ operator in the Selection view of view2. ``` Where field12 in (Select field11 From view1) ``` Hope this helps.
Denodo Team
10-08-2017 06:41:42 -0400
Hi Denodo Team! Can you describe that solution a little bit deeper? I'm getting the following sentence when trying to add the sub select statement under the "in" operator: WHERE p_t_cil_sae_adtype_temp.ca_tran_type in ('select distinct ca_tran_type from dv_tl_account_expense_copy')) But it is just executing a search for the text 'select distinct...' in the ca_tran_type column instead of matching the values. Is there anything I'm missing? Please, see the image of the where clause in VDP for the below query: ![](https://hackettgrp-my.sharepoint.com/personal/fguadalupe_thehackettgroup_com/_layouts/15/guestaccess.aspx?docid=1ec754b83823e46d88800dda5f6d7609a&authkey=ARhr-aYJxfbcKhXbHp9guSU) Thanks in advance for your time and help! Best, Fabian
user
 Edited on: 13-10-2017 10:51:10 -0400
Hi, In Virtual DataPort, specifying a value between single quotes is considered as a string. In order to specify the subquery in the where clause you should mention it within the parenthesis instead of single quotes. For example, ``` where p_t_cil_sae_adtype_temp.ca_tran_type in (select distinct ca_tran_type from dv_tl_account_expense_copy) ``` Hope this helps.
Denodo Team
16-08-2017 01:22:56 -0400
You must sign in to add an answer. If you do not have an account, you can register here