HANA Calculation view Union giving more records than source nodes, few records are Duplicated

[former_member626054]

Hi Experts,

I am facing an issue with HANA calculation view "UNION" Node. I have a HANA calculation view with 2 joins say, Join_1 and Join_2 . In data preview, I see both giving 6 records each . In next step i have a Union , say Union_1 which takes Join_1 and Join_2 as input. Now when I do data preview on the Union node, I get 16 records , 4 records extra. I was expecting 6+6 =12 records. The additional 4 records are actually duplicates . If anyone has faced this issue before can you let me know what could be the problem?

Thanks in Advance,

VM

[former_member285763]

Hello

vmeghmala cincet.frdric2 I am also facing the same issue in our project, Can you please help me if you got any rootcause/fix for this issue ?

[Pratiksha23]

Use a aggregation node on that union node without aggregating any measures it will remove all the duplicates.

[former_member626054]

Hi @kirankumar440

We tried a workaround, after UNION node we added another node remove the extra/duplicate rows.

[FCI]

Never encountered this kind of issue.

Is it possible that an implicit aggregation occurs when previewing the data at the join level ?

Can you check the result of both joins in dedicated calculation views without the union and by executing them (no preview)?

Regards,

Frederic

[former_member626054]

Hi Gopinath,

I checked the Join_1 and Join_2 , no join values show null in data preview.

Regards,

VM

[gopinath_kolli]

Please check if you have joining on columns which is carrying NULL values.