Script language not working

[#1]

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?

[jerrysvensson]

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;

[#3]

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

[jagan · Accepted solution]

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.