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.
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.
Hey here is more information link on C_LOCATION.
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.
Please check if all your statements after From ..... end correctly with ';'.
there is no need to give table name for your second table
Try same code removing second temppostal
In addition to the other comments, you should add quotes around $(ZipCode) in the load statement
'$(ZipCode)' as Postalcode,
Retrieving data ...