Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have columns for clinicname, attendanceid and date and am trying to get average number of attendances per clinic.
How do I use distinct to get 1 as value for clinic name per date and a count of attendances?
Thanks
Ian
I believe you just add DISTINCT to your script.
From your example:
LOAD DISTINCT Clinic_Code,
attendanceid,
date
FROM
(ooxml, embedded labels, table is Sheet1);
Hi,
I hope the attach applicatioon is what you are looking for.
Deepak
Hi,
Please find the attachment for solution.
Regards,
Jagan.