duplicate records in join

[Mahamed_Qlik]

Hi 

I have two table with same ID field common between them as below:

BILL:

BILL_ID

10001

PAYMENT:
BILL_ID

10001

whenever I join these two tables I am getting 2 records irrespective of other columns in both table.

I have used only BILL_ID field and joined then table still I am getting 2 records.

BILL:

Load BILL_ID From BILL;

left join (BILL)

Load BILL_ID From PAYMENT;

Resulting table:

BILL:

10001

10001

Kindly assist;

Regards,

Mahamed

[BrunPierre]

I recommend using ApplyMap Don't join - use Applymap instead, but providing more sample data(fields) might help explore alternatives.

[vinieme12]

1) Trim any leading/trailing spaces    TRIM(BILL_ID)

2) check if the relationship between these two tables is actually 1-1  or 1-n 

for example are there multiple payments rows in the payment table or multiple rows in BILL table for same BILL_ID