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
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](, 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]( for implementing an Extended Union. For more details on case statements, you can refer to [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