globalmap cannot be resolved

[Anonymous]

Hi there,

I am attempting to perform a join with a look up table with millions of rows through tMap.

The method I am using (as described at  https://www.talend.com/blog/2017/01/05/talend-job-design-patterns-best-practices-part-4/) is through the lookup mode "Reload at each row".

 I have set up the global map keys at this point, as well as defining these as the joining keys on the join table (see attachment 1).

I then filter on this on the lookup table of the tMap within the PostgreSql query (see attachment 2).

However, when I attempt to run this, I receive the error "globalmap cannot be resolved" and the job doesn't run, leaving the error in the code palette (see attachment 3).

Is there something I am doing incorrectly?

Thanks in advance for your help.

[TRF · Accepted solution]

Write "globalMap.get" instead of "globalmap.get"