Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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"
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"
Thanks Krishnamoorthy. It worked.
Could you please tell me why we need to do this?
Ramakanth