Calculation View and COALESCE

[alexander_stettler]

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,
Alex