on 04-09-2018 4:10 PM
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
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.