Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm loading data from a file like so:
LOAD Dept, Clinic, Meprs FROM [excel file on disk];
The data looks like this:
Dept1, Clinic1, Meprs1
Dept1, Clinic1, Meprs2
Dept1, Clinic1, Meprs3
Dept1, Clinic2, Meprs4
Dept1, Clinic2, Meprs5
Dept1, Clinic3, Meprs6
Dept1, Clinic3, Meprs7
Dept1, Clinic3, Meprs8
Dept1, Clinic3, Meprs9
Dept2, Clinic4, Meprs10
...and so on
I want to create the following table
Dept1, Clinic1, "Meprs1,Meprs2,Meprs3"
Dept1, Clinic2, "Meprs4,Meprs5"
Dept1, Clinic3, "Meprs6,Meprs7,Meprs8,Meprs9"
Dept2, Clinic4, "Meprs10"
...and so on
How would I go about doing that?
Never mind - I fingered it out:
NoConcatenate
PC_Clinics_2:
LOAD Dept,
Clinic,
CONCAT(MEPRS,',') AS MEPRSGroup
RESIDENT PC_Clinics
GROUP BY Dept,ClinicName;
Never mind - I fingered it out:
NoConcatenate
PC_Clinics_2:
LOAD Dept,
Clinic,
CONCAT(MEPRS,',') AS MEPRSGroup
RESIDENT PC_Clinics
GROUP BY Dept,ClinicName;
temp:
LOAD * INLINE [
F1, F2, F3
Dept1, Clinic1, Meprs1
Dept1, Clinic1, Meprs2
Dept1, Clinic1, Meprs3
Dept1, Clinic2, Meprs4
Dept1, Clinic2, Meprs5
Dept1, Clinic3, Meprs6
Dept1, Clinic3, Meprs7
Dept1, Clinic3, Meprs8
Dept1, Clinic3, Meprs9
Dept2, Clinic4, Meprs10
];
LOAD F1,F2,Concat(F3,',')
Resident temp
GROUP BY F1,F2