Skip to Content

Calculation View and COALESCE

Apr 09 at 03:10 PM


avatar image

Hello together,

I want to use a Calculation View for a BW data modeling request:

I have two tables (A and B) with the same data structure.
Table A has to be joined with B (LEFT OUTER JOIN) and if an entry in B exist a lot of characteristics should be used from B instead of A for the projection.

With SQL I would do this with COALESCE, but I could not find this functionality in a Calculation View. Is it necessary to work here with calculated fields and if statements, or is there another solution for this?

Best Regards,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers