topic Re: Left Join does duplication in QlikView

Left Join does duplication

Sat, 28 Jun 2014 22:46:45 GMT

Hi.

As i know from sql when you use left join the script goes:

table_A

left Join table_B on A.id = B.id

in qlikview script i do like this:

Table_A:

....

Left Join (Table_A)

load *

resident Table_B

"When i do that it duplicate rows, i guess it's because there is no expression of "on A.id = B.id

?how can i fix it

Re: Left Join does duplication

suzel404 — Sat, 28 Jun 2014 23:02:06 GMT

Table_B:

LOAD

FROM Table_B.qvd(qvd);

Table_A:

LOAD

FROM Table_A.qvd(qvd);

LEFT JOIN (Table_A)

LOAD

RESIDENT Table_B.qvd(qvd)

DROP Table Table_B;

Re: Left Join does duplication

eduardo_sommer — Sat, 28 Jun 2014 23:10:58 GMT

Hi Gil,

You probaly have more than one row in table B corresponding to one row in Table A. The association is done over columns with the same name on the two tables. Check all columns that should match has the same name in both tables.

Eduardo

Re: Left Join does duplication

Sun, 29 Jun 2014 04:09:34 GMT

Hi Gil

Left join shouldn't duplicate if the id is unique

Can you please post a sample it could jut ids

Regards

Padma

Re: Left Join does duplication

Anonymous — Sun, 29 Jun 2014 05:26:35 GMT

Hi,

You may have duplicates in Table B. You may use "Left Keep (Table A)" instead to eliminate duplicate issue.

PS: Left keep will keep two table separate however Table B will have only data which is associate to Table A.

Hope this helps you.

Thanks

Re: Left Join does duplication

Anonymous — Tue, 13 Feb 2018 15:50:30 GMT

Hello,

Load all fields from Table B to see the field who have two values different