Left Join duplicating the records in straight table in Front End in Qliksense

[konidena]

Hi Team, 

Here is the issue i am facing . Please help me here.

Table1:

%CustomerKey

Account

Sales

%DateId

KeyId

From Table path;

Left Join (Table1)

Table2: 

AccountKey

KeyId

from Table Path;

Left Join (Table1)

Table3:

AccountKey

AccountPlanKey

AccountPlanUnit

TablePath;

I am trying to show the sales by each Account from Table1. 

Issue: After I did the left join from table3, per one AccountKey there are more than one AccountPlan and it is valid. But due to this left join, my first table records are duplication. How to show only distinct records by each account from table1

[Dementor]

Hi, can you provide some dummy example what exactly are you expecting the output, with your thought process.Because if there are mulitple account key for each account then duplicate data is expected.Instead of joining Table3 directly, you can aggregate it to ensure that each accountkey appears only once, then try to join it.