You can translate the question and the replies:

Query on joining and updating.

I have a view, I need to update columnA with Column B if that columnA as null value , do we have denodo query for it.?
24-07-2019 22:51:25 -0400

1 Answer

Hi, For your case, I would define a CASE expression on fieldA in the output tab of my derived view as below, ``` CASE WHEN fieldA IS NULL THEN fieldB ELSE fieldA END ``` For more information, you could refer to section [Creating Selection Views]( of Virtual DataPort Administration Guide and [CASE Clause Examples]( of Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
25-07-2019 05:24:23 -0400
You must sign in to add an answer. If you do not have an account, you can register here