Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 outputimg2
here is a screenshot of my tmap and my job
img3
img3
img4
@9allel22 ,you have to use below way.
row6.YX_TYPE.equlas("LA2")?row6.YX_TYPE:"2"
or
("LA2").equlas(row6.YX_TYPE)?row6.YX_TYPE:"2"
@9allel22 ,you have to use below way.
row6.YX_TYPE.equlas("LA2")?row6.YX_TYPE:"2"
or
("LA2").equlas(row6.YX_TYPE)?row6.YX_TYPE:"2"
Good Luck my friend !
@9allel22 ,check the below way .
row6.YX_TYPE.contains("LA2")?row6.YX_TYPE:"2"
or
("LA2").contains(row6.YX_TYPE)?row6.YX_TYPE:"2"
here is the result of your first solution,
the second one gave me the output what i want, thank's for helping bro