You can translate the question and the replies:

Condition based Base view call

I am having 3 base views : A, B, C. I need to create a single business view (D) based on the below condition. Please let me know how to achieve this use case : If (Condition 1 satisifed) Then Base view A's should be displayed as D's output Else Base view B should be displayed as D's output If (Condition 2 satisifed) Then Base view C be displayed as D's outputoutputoutputoutput
user
26-07-2021 14:14:23 -0400

1 Answer

Hi, To accomplish this, create a selection view for each of your table by navigating to New > Selection and specify the condition under the Where tab as below, `case when <condition> then 1=1 else 1=0 end` Once those views are created, you can utilize the Extended Union to achieve this scenario, since it takes care of dissimilar views. To create the [Extended Union in Denodo 8.0](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/queries_select_statement/union_clause/union_clause), right-click on the Server Explorer and click File > New > Union (extended). Drag and drop the previously created selection views, connect them and save the view. For Denodo 7.0, please follow this [link](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/union_clause/union_clause) for implementing an Extended Union. For more details on case statements, you can refer to [CASE Clause](https://community.denodo.com/docs/html/browse/8.0/vdp/vql/queries_select_statement/case_clause/case_clause#case-clause) of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
28-07-2021 11:10:18 -0400
You must sign in to add an answer. If you do not have an account, you can register here