topic Re: Filter: string / integer in Talend Studio

Filter: string / integer

Anonymous — Sat, 16 Nov 2024 13:55:22 GMT

Hello,
I want to test the values of a field (ACBAC) in a tmap component:
row1.PFUNCO==4?StringHandling.LEFT(StringHandling.TRIM(row1.PFPN),8)+"/"+StringHandling.TRIM(row1.PFUNCO) tringHandling.TRIM(row1.PFPN)+"/"+StringHandling.TRIM(row1.PFUNCO)
currently it does not work!
It is strange because when I check the data type, ACBAC is an integer and when I test as an integer I get the following error:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Incompatible operand types String and int
When I test it as a string I don't have the error:
Starting job ArticlesUCv2 at 08:12 10/06/2009.
connecting to socket on port 3463
connected
disconnected
Job ArticlesUCv2 ended at 08:12 10/06/2009.
but it does always the "else" part of the condition.
example of the output data:
15366M0500/881 PPE MAZOUT AS47A 4
15366M0545/881 PPE MAZOUT AS47A +CABLE 4
15366P0500/K10 PPE MAZOUT AS47A 4
15366P0500/111 PPE MAZOUT AS47A 4
15366P0500/121 PPE MAZOUT AS47A 4

as you see I have ACBAC=4 and it does not extract the left part of the firts field
Any ideas how to debug it?
Thanks
Didier

Re: Filter: string / integer

Anonymous — Wed, 10 Jun 2009 07:22:12 GMT

new attached screenshot

Re: Filter: string / integer

Anonymous — Wed, 10 Jun 2009 07:23:20 GMT

screenshot

Re: Filter: string / integer

Anonymous — Wed, 10 Jun 2009 08:08:49 GMT

Hello

, ACBAC is an integer and when I test as an integer I get the following error:

ACBAC is an integer, but you set a string to it, so it will throws this exception.

as you see I have ACBAC=4 and it does not extract the left part of the firts field

From your result, I see this is one of records of PFUNCO:
881 PPE MAZOUT AS47A 4
Only the last char is 4, why don't you say 'I have ACBAC=4', you need get the last char and set it as condition.
Aslo, if the data type of ACBAC is string, you should define the expression as:
row1.PFUNCO.equals("xxx")?StringHandling.LEFT(StringHandling.TRIM(row1.PFPN),8)+"/"+StringHandling.TRIM(row1.PFUNCO) tringHandling.TRIM(row1.PFPN)+"/"+StringHandling.TRIM(row1.PFUNCO)

Re: Filter: string / integer

Anonymous — Wed, 10 Jun 2009 09:25:22 GMT

Hi Shong,
Thanks for your recommandations
I have found my misstake
Didier