on 06-13-2017 7:05 PM
We are trying to merge two queries by a common dimension and we would like to perform Left Join as query1 data Left Join query2 data. We did this by displaying the merged dimension column from query1 instead of merged dimension itself.
But, the results are produced using inner join instead of Left outer join. If we display merged dimension itself, it is considering Full Outer Join. Can you help us resolve this issue.
Hi,
if you use dimensions from query 2 it will be an inner join, set them as detail upon your merged dimension
Grtz
Koen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.