Help with Load * INLINE and where exist

Anonymous — Thu, 19 Jul 2012 13:45:54 GMT

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;

Re: Help with Load * INLINE and where exist

swuehl — Thu, 19 Jul 2012 13:49:01 GMT

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.

Re: Help with Load * INLINE and where exist

Anonymous — Thu, 19 Jul 2012 13:55:16 GMT

Thank you It's work now

Re: Help with Load * INLINE and where exist

Anonymous — Thu, 19 Jul 2012 13:57:24 GMT

Thanks Lot !!

topic Re: Help with Load * INLINE and where exist in QlikView

Help with Load * INLINE and where exist

Re: Help with Load * INLINE and where exist

Re: Help with Load * INLINE and where exist

Re: Help with Load * INLINE and where exist