Script

[rathnam_qv]

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

[m_woolf]

You can't use aggregation functions in script without using GroupBy

[rathnam_qv]

Hi Michael,

can u send me the script please