topic Re: script load shows error missing' ) 'bracket,need help please. in QlikView

script load shows error missing' ) 'bracket,need help please.

Tue, 24 Jun 2014 05:57:50 GMT

Hi all,

I kindly request your help to resolve the below issue.

I have attached an application which has 2 fields in the script.but here the reload gives an error as 'missing a bracket")" 'I have checked the brackets of the if statement which are proper to my knowledge.Please can someone check the script and let me know what is missing.

Because of this the key words as,from are not highlighted also ???

regards,

sahana

Re: script load shows error missing' ) 'bracket,need help please.

phaneendra_kunc — Tue, 24 Jun 2014 06:07:10 GMT

it is because of at the end you are trying to load URL with wrong format...

you just have single quotes around just on TEST.

try adding single quotes to entire text.

'all your URL text'

Re: script load shows error missing' ) 'bracket,need help please.

sasikanth — Tue, 24 Jun 2014 06:11:14 GMT

HI sahana

Error in last IF statement

( wildmatch(Counterparty,'*NOBLE RESOURCES INTERNATIONAL PT*','*TAMATAMA*','*BARA MITRA*')>=1,

'TEST' https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor, Counterparty)))))))))) as Counterparty1

in the above single quotes are there only for TEST, see below

Load like below

LOAD valRef,
if( wildmatch(Counterparty,'*PT ATLAS RESOURCES*')>=1,'ATLAS',
if( wildmatch(Counterparty,'*BERAU*','*MAPLE*')>=1,'BERAU',
if( wildmatch(Counterparty,'*COCKATOO*')>=1,'COCKATOO',
if( wildmatch(Counterparty,'*PLACEHOLDER*')>=1 & WildMatch([Noble Contract ID],'*ILFS*')>=1,'ILFS',
if( wildmatch(Counterparty,'PT ASMIN KOALINDO TUHUP')>=1,'AKT OFFTAKE',
if( wildmatch(Counterparty,'ASTON COAL 2 PTY LTD')>=1,'ASTON',
if( wildmatch(Counterparty,'LEDJADJA COAL (PTY) LTD')>=1,'RES GEN',
if( wildmatch(Counterparty,'*BLUESCOPE*')>=1,'BLUESCOPE',
if( wildmatch(Counterparty,'*YANCOAL*')>=1,'YANCOAL CMA',
if( wildmatch(Counterparty,'*NOBLE RESOURCES INTERNATIONAL PT*','*TAMATAMA*','*BARA MITRA*')>=1,
'TEST https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor', Counterparty)))))))))) as Counterparty
FROM

(ooxml, embedded labels);

Re: script load shows error missing' ) 'bracket,need help please.

Tue, 24 Jun 2014 06:11:58 GMT

hi Phaneendra,

thanks a lot

Re: script load shows error missing' ) 'bracket,need help please.

crusader_ — Tue, 24 Jun 2014 06:37:24 GMT

Hi,

The problem is in this string, not in brackets:

'TEST'https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor

I don't know what did you want but if you change to

'TEST'&'https://mail.google.com/mail/u/0/?logout&hl=en-GB&hlor'

Andrei