topic Re: Tmap condition expression problem in Talend Studio

Tmap condition expression problem

Anonymous — Mon, 11 Mar 2019 09:56:05 GMT

hi everyone, i'm a begginer in talend looking for a solution to my problem;
So, here my screen shots:
in fact, i have two tables in two different databases, and i have only one output.
i'm recovering a column (YX_TYPE) from table 2(row6) in the output,
here is the output result:
img1
until here, everything is ok
when i put a condition in my tmap expression : (row6.YX_TYPE="LA2"?row6.YX_TYPE:"2" )
if YX_TYPE="LA2" (show row6.YX_TYPE) (LA2)
else show "2"
i don't know if i made a syntax mistake
here is the resut of my output
img2

here is a screenshot of my tmap and my job

img3

img3img4

Re: Tmap condition expression problem

manodwhb — Mon, 11 Mar 2019 09:58:29 GMT

@9allel22 ,you have to use below way.

row6.YX_TYPE.equlas("LA2")?row6.YX_TYPE:"2"

("LA2").equlas(row6.YX_TYPE)?row6.YX_TYPE:"2"

Re: Tmap condition expression problem

Anonymous — Mon, 11 Mar 2019 10:09:08 GMT

Good Luck my friend !

Re: Tmap condition expression problem

manodwhb — Mon, 11 Mar 2019 10:14:38 GMT

@9allel22 ,check the below way .

row6.YX_TYPE.contains("LA2")?row6.YX_TYPE:"2"

("LA2").contains(row6.YX_TYPE)?row6.YX_TYPE:"2"

Re: Tmap condition expression problem

Anonymous — Mon, 11 Mar 2019 10:14:56 GMT

here is the result of your first solution,

the second one gave me the output what i want, thank's for helping bro