Need help to use globalMap's column name's VALUES in tMap Filter Expression.

[DHazari1598547528]

We are using tMap for the following:

1. We are joining source and target table on key columns source.id= target.id

2. We are using globalMap to store the name of some columns for both the source and target.

3. Global Map contains the following values:

source_hash_column > hash_key

3. We want to use the column name stored in the globalmap, in the Filter Expression of tMap output.

(source.((String)(globalMap.get("hash_key")) == null)

4. Now issues are:

a) If we use it the way mentioned in point 3, it gives compilation error: Syntax error on token ".", Identifier expected after this token.

b) If we use concatenation like below, then its treating column names itself as String and Not the actual value stored in that column.

(source + "." + ((String)(globalMap.get("hash_key")) == null)

Can someone please suggest, how can we use globalMap's column name's values in tMap Filter Expression?

[manodwhb]

@MADHUSUDHANA kolli​ ,check the attached job.

Thanks,

Manohar

[madhukolli2003]

Hi @Manohar B​ ,

Sorry, I am not able to import your job. I am using older version.

Can you please share screen shot of tMap, I want to see how you are parsing global variable in it.

Thanks & Regards,

Madhu Kolli