Help with Load * INLINE and where exist

[Anonymous]

I need some help with this script why I got this error message after load the script:

Garbage after statement

EmplHist:
LOAD EMPL_ID,
  FULL_NAME,
  Status,
  HOME_ORG_ID,
  TITLE_DESC,
  GLC
 
RESIDENT TempEmployeeHist
WHERE EXISTS (DirOrgList, HOME_ORG_ID)

DROP TABLE TempEmployeeHist

---------------------------------------------

// First Tab:

//

// List of ORG ID containing Direct Billable Rate

//

DirOrgList:

LOAD * INLINE [

DirectOrg

'1.ABP.HLT.24'

'1.ABP.HLT.57'

'1.ABP.HSV.25'

'1.ABP.HSV.58'

];

// Second Tab

TempEmployeeHist:
LOAD   EMPL_ID,
    LAST_NAME & ', '& FIRST_NAME as [FULL_NAME],
    S_EMPL_STATUS_CD as Status;
   
SQL SELECT *
FROM $(vSchemaOwner).EMPL;

LEFT JOIN (TempEmployeeHist)
LOAD   EMPL_ID,
    ORG_ID as [HOME_ORG_ID],
    TITLE_DESC,
    GENL_LAB_CAT_CD as GLC,
    DATE(END_DT);

SQL SELECT *
FROM $(vSchemaOwner).EMPL_LAB_INFO;

//***********************
EmplHist:
LOAD EMPL_ID,
  FULL_NAME,
  Status,
  HOME_ORG_ID,
  TITLE_DESC,
  GLC
 
RESIDENT TempEmployeeHist
WHERE EXISTS  (DirOrgList, HOME_ORG_ID)

DROP TABLE TempEmployeeHist;

[swuehl · Accepted solution]

Don't you miss a semicolon (' ; ') before the last drop table?

edit:

And I think it should be the field name DirectOrg instead of table name DirOrgList in the where exists clause.

[Anonymous]

Thank you It's work now

[Anonymous]

Thanks Lot !!