Skip to Content
0
Former Member
May 16, 2018 at 02:48 PM

SAP HANA Duplicate records after join

1206 Views

Hi all,

I am data modeling a ISH data model mixed with billing data.

After testing some results of the calculation view created, I am facing duplicate records.

Is there any way to avoid duplicate records after a join in the following example:

TABLE 1

Case1 100$

Case2 500$

TABLE 2

Case1 Mov1

Case1 Mov2

Case1 Mov3

Case2 Mov4

Case2 Mov5

With the Table 1 I get the billing per case, and after the join with the movemnets details of each case I get the following result

RESULT

Case1 Mov1 100$

Case1 Mov2 100$

Case1 Mov3 100$

Case2 Mov4 500$

Case2 Mov5 500$

So, in reporting, I get for Case1 a total of 300$ and for Case2 1000$

Please note, that this is only example, there could be a lot of fields involved in Table2.

Kind regards