topic Re: Find greater than for string value in tmap in Talend Studio

Find greater than for string value in tmap

j_ — Fri, 15 Nov 2024 23:32:19 GMT

Hi ,

I have a derived field for which i get to populate by checking the if else condition of source field ..The source field is string . ,

Let us assume the field is account .

IF account equals "aa" then the value is "A"

IF account equals "bb" then value is "B"

IF account is GREATER THAN "cc" then value is "D"

Re: Find greater than for string value in tmap

gjeremy1617088143 — Tue, 09 Nov 2021 13:18:44 GMT

Hi, you can try this ternary exrpession:(i assume your input come from row1 main link)

row1.account.equals("aa")?"A": (row1.account.equals("bb")?"B":(!row1.account.equals("cc")?"D":(values for other case)))

IF account equals "aa" then the value is "A"

ELSE IF account equals "bb" then value is "B"

ELSE IF account not equals "cc" then value is "D"

ELSE VALUE for cc

send me love and kudos

Re: Find greater than for string value in tmap

j_ — Wed, 10 Nov 2021 06:48:04 GMT

Hi IF case ternary operater is okay but how do we find greater than for string (Ascii code) ..For first 2 case its equal to so its easy..For 3rd its finding greater than value.

Re: Find greater than for string value in tmap

gjeremy1617088143 — Wed, 10 Nov 2021 09:55:05 GMT

maybe you can use String.compareTo java method :

ex : "a".compareTo("b") return -1 a<b

"c".compareTo("b") return 1 c>b

"a".compareTo("a") return 0 a=a

send me love and kudos

Re: Find greater than for string value in tmap

j_ — Sat, 27 Nov 2021 19:07:02 GMT

Hi this worked thanks for the reply