topic Re: tMap Expression writing syntax, filter in tMap in Talend Studio

tMap Expression writing syntax, filter in tMap

Anonymous — Sat, 16 Nov 2024 04:01:20 GMT

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

Re: tMap Expression writing syntax, filter in tMap

Anonymous — Tue, 26 Nov 2019 05:57:08 GMT

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

Regards
Shong

Re: tMap Expression writing syntax, filter in tMap

Anonymous — Tue, 26 Nov 2019 06:18:25 GMT

Hi Shong,

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

Re: tMap Expression writing syntax, filter in tMap

Anonymous — Tue, 26 Nov 2019 06:26:07 GMT

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

Re: tMap Expression writing syntax, filter in tMap

TRF — Tue, 26 Nov 2019 07:19:01 GMT

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)

Re: tMap Expression writing syntax, filter in tMap

Anonymous — Tue, 26 Nov 2019 08:49:59 GMT

Hi,

Please have the screen shots to understand the problem.

Regards

Guru

Error.docx

Re: tMap Expression writing syntax, filter in tMap

Anonymous — Wed, 27 Nov 2019 01:22:24 GMT

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