topic Resident Load returns additional rows in App Development

Resident Load returns additional rows

JohnMcPhee — Thu, 22 Apr 2021 18:25:17 GMT

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

Re: Resident Load returns additional rows

rwunderlich — Thu, 22 Apr 2021 21:38:44 GMT

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

-Rob

Re: Resident Load returns additional rows

JohnMcPhee — Fri, 30 Apr 2021 12:42:32 GMT

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.