"Syntax error, missing/misplaced FROM:" Maps

[#1]

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

[swuehl]

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.

[#3]

Hey here is more information link on C_LOCATION.

[#4]

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

[Anonymous]

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,

[Colin-Albert]

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

concatenate(temppostal)

load

     '$(ZipCode)' as Postalcode,

     ...