tMap Expression writing syntax, filter in tMap

[Anonymous]

Hi All,

From below CSV file I have to pull the data related to Country England in one output file and in another CSV file without Country England. How to write 2 expressions. 

I have written like this : row1.Country.equals("England") , row1.Country!=England

But it's throwing an error Type Mismatch: Cannot convert from boolean to String

LastName;Gender;Age;Salary;Country

Buren;M;73;14500;England

Adams;M;40;30000;England

Jefferson;F;66;56000;USA

Adams;M;9;28800;England

Jefferson;M;30;46000;China

Carter;F;26;45000;England

Harrison;M;40;45788;UAE

Roosevelt;F;15;56000;England

Monroe;M;8;5000;England

Arthur;M;20;36777;USA

Pierce;M;18;100000;England

Quincy;F;83;49888;UAE

McKinley;M;70;39000;England

Coolidge;M;4;56000;India

Monroe;M;60;24000;England

Thanks in advance for your help

Regards

Guru

[Anonymous]

change
row1.Country!=England
to
!row1.Country.equals("England")

Regards
Shong

[Anonymous]

Hi Shong,

Still throwing same error. Type Mismatch: Cannot convert from boolean to String

[Anonymous]

where do you write the expression? Can you upload a screenshot of tMap?

[TRF]

Use tFilterRow to exclude "England" rows.
You can also add an expression filter within a tMap input flow (tMap left side). In this case use the following syntax:
!"England".equals(row1.country)

[Anonymous]

Hi,

Please have the screen shots to understand the problem.

Regards

Guru

Error.docx

[Anonymous · Accepted solution]

Hi,

You are giving the condition expression in wrong area.

Please refer below help link to understand how to write expressions inside tMap.

https://help.talend.com/reader/u8p7D8I8mmr4JVdAEYllMA/FOi3TpyD9Vio1IWKCsfG~w

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved