on 01-20-2017 7:48 AM
Dear All,
I have the following issue:
Table 1
Doc No Approver
1 abc
1 def
Table 2
Doc no Item no Product qty
1 10 100
1 20 200
When I create a BW Composite Provider of Inner JOIN Table 1 (DSO1)to Table 2(DSO2)
I get the output as
Doc Approver Item Qty
1 abc 10 100
20 200
1 def 10 100
20 200
I am looking for output
1 abc 10 100
1 def 20 200
I tried various cardinality but still does not work. Is there any way to get this output?
Hi Ramachandran,
Here Joining only on Doc no will give only same result.
The output you are looking for can be obtained, only when you can join it on some other Column along with doc no
Thanks,
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.