Q&A BY TAG 'union'

You must sign in to ask a question. If you do not have an account, you can register here

Unparseable date in union
answered 07-05-2015 11:47:17 -0400

Denodo 5.0 release 20141023 - Windows Server 2008R2. I have three views that I am trying to union together. view1 and view2 have 10 fields in it, view3 only has 8 fields. view3 is missing 2 date fields so I created 2 new date fields in view3. The dat...

Answers: 1


Union View Error of Assert code: 1000 Help
answered 29-04-2015 14:22:22 -0400

I am using the 5.5 Community Edition. In there I create two new join views that each have two columns (email & touchpoint). Each of those views when executed pull back what is expected. Next I went to create a union view that uses those two previous...

Answers: 2


How many CASE statements are allowed in one view?
answered 24-11-2014 10:56:02 -0500

Hi I have a question regarding the CASE statement and how many can be used in creating a view. I have two views joined in a UNION. I have multiple fields where I have applied the following statement: Case WHEN (view1.field1 is null) THEN view2.fiel...

Answers: 1