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.