topic Re: Script language not working in QlikView

Script language not working

Wed, 10 Sep 2014 07:21:41 GMT

I'm trying to use the Lookup() function in my script but the Lookup() isn't turning blue and when I load the error says the function doesn't exist? I have a feeling that the script isn't recognising the Qlik language but I don't know how to go about telling it to understand Qlik language:

LOAD [Internal Number],

     [External Number],

     Mobile,

     contno,

     [Company Name],

     [Contact Name],

     [Email Address],

     [Email Company Capture],

     Department

FROM
[Contact Database.xlsx]

(ooxml, embedded labels, table is Lookup);

CONNECT32 TO dbserver_logging;

SQL SELECT accountcode,

    answered,

    callcost,

    callfrom,

    Lookup('Contact Name','Internal Number',callfrom,'Lookup') as 'Call From'

FROM logging.phone;

Can anyone help?

Re: Script language not working

jerrysvensson — Wed, 10 Sep 2014 07:49:25 GMT

Put Lookup in the load statement.

LOAD *,

Lookup('Contact Name','Internal Number',callfrom,'Lookup') as 'Call From'

;

SQL SELECT accountcode,
    answered,
    callcost,
    callfrom
FROM logging.phone;

Re: Script language not working

Wed, 10 Sep 2014 07:52:58 GMT

Will that add the lookup column to the SQL select table?

Re: Script language not working

jagan — Wed, 10 Sep 2014 07:57:52 GMT

Hi,

Check this link

Lookup function

Try like this, Lookup is Qlikview function, so you have to use Precedent load.

LOAD

Lookup('Contact Name','Internal Number',callfrom,'Lookup') as 'Call From';

SQL SELECT accountcode,
    answered,
    callcost,
    callfrom

FROM logging.phone;

Hope this helps you.

Regards,

Jagan.