Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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
Author

Hey here is more information link on C_LOCATION.

clocation.JPG.jpg

Not applicable
Author

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


Anonymous
Not applicable
Author

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.

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Colin-Albert

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

concatenate(temppostal)

load

     '$(ZipCode)' as Postalcode,

     ...