topic Re: "Syntax error, missing/misplaced FROM:" Maps in QlikView

"Syntax error, missing/misplaced FROM:" Maps

Wed, 19 Mar 2014 18:44:19 GMT

Hi Gurus,

Here I am attaching the snapshot of my code and the error message I am getting.

Please help me out resolve this issue.

Thank you very much.

Regards,

Pramod

Re: "Syntax error, missing/misplaced FROM:" Maps

swuehl — Wed, 19 Mar 2014 18:55:35 GMT

Your ZipCode variable is not properly set using

Let ZipCode = Peek('postal',$(i),'C_LOCATION');

You haven't shown the code for table C_LOCATION, so it's hard to tell why.

Try using the debug mode to step through your code.

Re: "Syntax error, missing/misplaced FROM:" Maps

Wed, 19 Mar 2014 19:05:50 GMT

Hey here is more information link on C_LOCATION.

Re: "Syntax error, missing/misplaced FROM:" Maps

Thu, 20 Mar 2014 12:23:04 GMT

Please check if all your statements after From ..... end correctly with ';'.

Re: "Syntax error, missing/misplaced FROM:" Maps

Anonymous — Thu, 20 Mar 2014 12:26:49 GMT

Is there a chance that in some records "postal" is null? If yes, you either have to filter out these records, or replace this null with some default value.

Re: "Syntax error, missing/misplaced FROM:" Maps

PrashantSangle — Thu, 20 Mar 2014 12:28:17 GMT

Hi,

there is no need to give table name for your second table

Try same code removing second temppostal

Regards,

Re: "Syntax error, missing/misplaced FROM:" Maps

Colin-Albert — Thu, 20 Mar 2014 12:37:08 GMT

In addition to the other comments, you should add quotes around $(ZipCode) in the load statement

concatenate(temppostal)

load

'$(ZipCode)' as Postalcode,

...