topic Error with syntax... boolean to string error in Talend Studio

Error with syntax... boolean to string error

Edi1 — Thu, 01 Apr 2021 16:29:23 GMT

Hello,

Please help me with this syntax.

This one cannot convert from boolean to string:

(row1.Cost_Center.equals("Cost Center")||row1.Cost_Center.equals("Work Breakdown Center")||row1.Cost_Center.equals("Network Center"))

This syntax is not working:

String.valueOf(row1.Cost_Center.equals("Cost Center")||row1.Cost_Center.equals("Work Breakdown Center")||row1.Cost_Center.equals("Network Center"))

The input schema is a String. Output schema is a String

one of the cost centers. it can be Cost Center, Work Breakdown Center, or Network Center

Re: Error with syntax... boolean to string error

gjeremy1617088143 — Thu, 01 Apr 2021 19:11:29 GMT

Hi as i see if it’s in a tmap Column: it’s because you only have the condition, there is no value set where condition is reached or not. So talend read it as a boolean

Re: Error with syntax... boolean to string error

gjeremy1617088143 — Thu, 01 Apr 2021 19:25:53 GMT

If you want to filter the cost center That respect only Your condition put Your sentence in the filter expression editor of your input. And invert string position to make it null safe (ex: "Cost Center".equals(row1.Cost_Center) instead of row1.Cost_Center.equals("Cost Center") )

Re: Error with syntax... boolean to string error

Edi1 — Thu, 01 Apr 2021 19:35:00 GMT

Ok, I will try to see how this format works. Thanks gjeremy!

Re: Error with syntax... boolean to string error

Edi1 — Thu, 01 Apr 2021 19:59:41 GMT

@gjeremy,

It looks better but not good since it is now giving output of all false. Do you know what I can change here?

String.valueOf("Cost Center".equals(row1.Cost_Center)||"Work Breakdown Center".equals(row1.Cost_Center)||"Network Center".equals(row1.Cost_Center))

The output is to be a valid cost center number or nothing.

Re: Error with syntax... boolean to string error

gjeremy1617088143 — Fri, 02 Apr 2021 08:52:56 GMT

Re: Error with syntax... boolean to string error

gjeremy1617088143 — Fri, 02 Apr 2021 08:55:25 GMT

as you can see Center is not in the filter so i'll not be in the output

Re: Error with syntax... boolean to string error

Edi1 — Fri, 02 Apr 2021 13:27:46 GMT

Ok, Thanks, I will look into it today.

Re: Error with syntax... boolean to string error

Edi1 — Fri, 02 Apr 2021 14:12:03 GMT

@guenneguez jeremy

Thanks gjeremy! 😂 Solved. It was just row1.Cost Center (no space)

Re: Error with syntax... boolean to string error

Edi1 — Fri, 02 Apr 2021 14:13:59 GMT

Your posts were extremely helpful @guenneguez jeremy