Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i hv writen the following script in the editor...
can any one help is it correct or not
CHAS_EXTRACT_2013:
LOAD RAM_HMDA_PURPOSE,
RAM_GEO_STATE,
RAM_GEO_COUNTY,
RAM_GEO_CENSUS_TRACT,
RAM_ACTION_TYPE,
RAM_HMDA_TYPE,
RAM_ACTION_DATE_YMD,
RAM_ACTION_DATE_CY,
BORROWER_SEG,
count(if(RAM_GEO_INC_SEG='L',1,0))as [Low Tract],
count(if(RAM_GEO_INC_SEG='M',1,0))as [Moderate Tract],
if(RAM_GEO_INC_SEG='L',sum(RAM_LOAN_AMT),0) as [Low Income],
if(RAM_GEO_BORROWER_INC_SEG='M' and BORROWER_SEG ='M',sum(RAM_LOAN_AMT),0) as [Moderate Income],
RAM_LOAN_AMT
Thanks in advance!!!
Smiley
You can't use aggregation functions in script without using GroupBy
Hi Michael,
can u send me the script please