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.?
user
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](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views#creating-selection-views) of Virtual DataPort Administration Guide and [CASE Clause Examples](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/case_clause_examples/case_clause_examples#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