Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
CLAIMS_REPORT_DEC:
LOAD
AutoNumber(AS_OF & '|' & CLAIM_NO) AS Claims_All_Link,
Count (DISTINCT CLAIM_NO) as Count_Claims
FROM
$(V_Layer1_QVD)\CLAIMS_REPORT.qvd
(qvd)
where Month(Date#( AS_OF,'YYYYMM')) = 'Dec'
Group by AS_OF ;
Attached is the error I am getting. What am I doing wrong here?
You will have to add CLAIM_NO to the group by clause as well.
May be this:
CLAIMS_REPORT_DEC:
LOAD
AutoNumber(AS_OF & '|' & CLAIM_NO) AS Claims_All_Link,
Count (DISTINCT CLAIM_NO) as Count_Claims
FROM
$(V_Layer1_QVD)\CLAIMS_REPORT.qvd
(qvd)
where Month(Date#( AS_OF,'YYYYMM')) = 'Dec'
Group By AS_OF & '|' & CLAIM_NO;
Hi,
Can you upload sample data sheet.
Rgds,
Dinu'1