on 07-08-2019 3:53 PM
Hi there,
I'd like to Combine or Join the 2 data sources
to then search for and calculate specific data, e.g. the sum of specific cost centre bookings and the sum of all goods-out postings both for the same date. To then show them side-by-side as calculated key figure, e.g. Column A: 200 EUR and Column B: 300 kg on the 3rd of May 2019.
Unfortunately the only overlapping info in both data sources are
SCMCFJU01 < > FINGLAU02
BT_DATE < > POSTING_DATE
PE_UUID < > PROFITCTR_UUID
As I have some more (2-4) selection criteria for each source I'd like to ask for a best practice how to merge these 2 data sources when these 4 characterstics are the only overlapping ones. At the moment I'm only able to combine these 2 data sources and my selections will only generate the requested data from one of the sources.
Regards
Alex
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.