Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

"Syntax error, missing/misplaced FROM:" Maps

Hi Gurus,

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

mapcode.JPG.jpg

maperror.JPG.jpg

Please help me out resolve this issue.

Thank you very much.

Regards,

Pramod

6 Replies
MVP
MVP

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

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.

Not applicable

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

Hey here is more information link on C_LOCATION.

clocation.JPG.jpg

Not applicable

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

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


mov
Esteemed Contributor III

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

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

Hi,

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

Try same code removing second temppostal

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

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

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

concatenate(temppostal)

load

     '$(ZipCode)' as Postalcode,

     ...