topic Re: How to show the extra rows in when doing the left join in QlikView

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

ashmitp869 — Tue, 24 May 2022 22:38:18 GMT

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.

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

marcus_sommer — Wed, 25 May 2022 08:03:17 GMT

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

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

edwin — Wed, 25 May 2022 18:12:58 GMT

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