Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am fetching data from Qvd with max number combined key. Numbers are 0,1,2,3,4,5,6 present in number field. But it showing only 1,2,3,4,5 numbers data. Following is the sample script. Thanks in Advance.
Mart:
LOAD
Distinct POL_NO&max(ENDOR_NUM) as polKey1%,
POL_NO,
max(ENDOR_NUM) as ENDOR_NUM_MAX
FROM
\\Path\Mart.qvd
(qvd) Group by POL_NO;
Left Keep(Mart)
LOAD
Distinct POL_NO&ENDOR_NUM as polKey1%,
ENDOR_NUM,
MONTH,
LOCATION_NAME,
BRANCH_NAME,
PUNCH_DATE
FROM
\\Path\Mart.qvd
(qvd);
Likely going to need to attach QVW and QVD on this one for anyone to have a serious look at things and provide some ideas on what could be going wrong, rather difficult to say without those sources to dig into. You could reduce the data in the QVD etc. to minimum needed to see the issue, but pretty sure that is going to be necessary in order to try to help given you have received no responses thus far.
Regards,
Brett