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.
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,
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.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.