I've experienced very, very strange situation as the SQL experienced employee. So after Left Joining two tables, I've got less rows on the output... For many reasons it can be more rows due to duplicates etc., but it shouldn't be less rows.
What are the possible reasons and the solutions for that critical issue?
The keys are generated via Autonumber() and it has the same seed, furthermore I haven't got the NULLs on these fields.
I'll try to prepare the file and the script.
27-3-2017 16:41:31: 0030 Binary [..\XXX.qvw]
27-3-2017 16:41:51: 0031 Let vNumberOfRows = NoOfRows('FINAL')
I think this is due to some quirky behaviour in the way QV handles DISTINCT. If you join with a distinct table, the DISTINCT operation propagates upward to the first table, so it de-duplicates the first table, reducing the number of rows.
To avoid this, assuming you need the DISTINCT, you may need to distinct load the second table into a resident table, and then left join the resident table to the binary loaded table.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein