Resident Load returns additional rows

[JohnMcPhee]

Hello, 

I have noticed some issues in calculation that we were doing from a resident load. From there I decided to compare the amount of rows in the initial QVD load and the resident load of that qvd and found that it is returning different amount of rows. 

Any ideas?

[table1]:
LOAD
RT_ID,
RVA_ID,
RT_RVAID,
RespDt ,
(many more fields)
FROM [lib://CL_QVD_Transform/CL_TR_Transports.qvd]
(qvd);

Let vCnt1 = NoOfRows('table1');

trace 'vCnt1 =' $(vCnt1); //returns 4,302,245

table2:
NoConcatenate
LOAD Distinct
RT_ID,
RVA_ID,
RT_RVAID,
RespDt

(many more fields)

Resident table1;


Let vCnt2 = NoOfRows('table2');

trace 'vCnt2 =' $(vCnt2);   // returns 4,304,978

drop table table1

[rwunderlich]

Can you check the rows counts as posted in the script log?

-Rob

[JohnMcPhee]

One of the fields in the originally loaded QVD was generated with a wildcard and once this was changed the issue stopped. I still don't understand why this is an issue but it is resolved.