Discussion board where members can get started with QlikView.
As i know from sql when you use left join the script goes:
left Join table_B on A.id = B.id
in qlikview script i do like this:
Left Join (Table_A)
"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
LEFT JOIN (Table_A)
DROP Table Table_B;
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.
Left join shouldn't duplicate if the id is unique
Can you please post a sample it could jut ids
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.
Load all fields from Table B to see the field who have two values different