How to show the extra rows in when doing the left join

[ashmitp869]

Hi ,

I have got two table A and B.

A got record 5000 when doing left join with B , 

Please assist with a query that will give me the results of extra rows.

[marcus_sommer]

The attempt to detect unwanted extra records after a join-statement could become quite tedious. Better is mostly to avoid such scenarios by Don't join - use Applymap instead - Qlik Community - 1467592.

- Marcus

[edwin]

there really is no concept of extra rows.  if the join results in multiple rows then there is no distinction whether the first is the valid row and the second an extra row. 

one way is to add a unique row ID, Rowno() to the main table.  then after the left join you can count the number of occurrences of the row number, this will allow you to identify multiple rows