Invalid expression with Min statement

[#1]

I get the following error:

Invalid expression

InvoicesAging:

LOAD "TRAIL_ID" as "AG_TRAIL_ID",

           "A_ENTITY_ID"  as "AG_ENTITY_ID",

           "A_HEADER_ID" as "AG_HEADER_ID",

           "A_ENTITY_ID"&"A_HEADER_ID" as "ENTITY_HEADER",                     

           "STEP_NAME" as "AG_STEP_NAME",          

           "END_DATE" as "AG_END_DATE",

           "AUDIT_STATUS" as "AG_AUDIT_STATUS",

           "OUTCOME" as "AG_OUTCOME",

           "CURRENT_ASSIGNEE" as "AG_CURRENT_ASSIGNEE",

           Min("START_DATE") as "AG_START_DATE",          

          Age(Timestamp(Now()),"START_DATE") as "AGE"

Resident Audit Where Match(Len("END_DATE"),0)

Group by "TRAIL_ID","A_ENTITY_ID","A_HEADER_ID","STEP_NAME","END_DATE","AUDIT_STATUS","OUTCOME","CURRENT_ASSIGNEE"

Could any one tell me whats wrong with this ?

Thanks

Ramakanth

[nagaiank · Accepted solution]

Try this.

InvoicesAging:

LOAD *, Age(Timestamp(Now()),"AG_START_DATE") as "AGE";

LOAD "TRAIL_ID" as "AG_TRAIL_ID",

           "A_ENTITY_ID"  as "AG_ENTITY_ID",

           "A_HEADER_ID" as "AG_HEADER_ID",

           "A_ENTITY_ID"&"A_HEADER_ID" as "ENTITY_HEADER",                     

           "STEP_NAME" as "AG_STEP_NAME",          

           "END_DATE" as "AG_END_DATE",

           "AUDIT_STATUS" as "AG_AUDIT_STATUS",

           "OUTCOME" as "AG_OUTCOME",

           "CURRENT_ASSIGNEE" as "AG_CURRENT_ASSIGNEE",

           Min("START_DATE") as "AG_START_DATE"

Resident Audit Where Match(Len("END_DATE"),0)

Group by "TRAIL_ID","A_ENTITY_ID","A_HEADER_ID","STEP_NAME","END_DATE","AUDIT_STATUS","OUTCOME","CURRENT_ASSIGNEE"

[#3]

Thanks Krishnamoorthy. It worked.

Could you please tell me why we need to do this?

Ramakanth