topic tMap if condition in Talend Studio

tMap if condition

Anonymous — Thu, 06 Feb 2020 14:58:32 GMT

Hi Everyone!

I am trying to do an if statement in the tMap component in Talend and it seems that I am just getting nulls back with my calculation. I am doing an exercise where I have to change the 1st number of the row to 19 or 20 based on the number. If the 1st number == 1 then replace it with 20 and if the 1st number == 0 replace it with 19. I will then convert the outputted number to a different date format. The data type is currently a string.

Example:

1040202 --> 20040202 --> 2004-02-02
0990930 --> 19990930 --> 1999-09-30
1141030 --> 20141030 --> 2014-10-30
1090613 --> 20090613 --> 2009-06-13

The Calculation I am currently using is to get to the second step in the proccess (replacing 0 to 19 and 1 to 20):

StringHandling.LEFT(row1.date,1)=="1"? StringHandling.EREPLACE(row1.date,StringHandling.LEFT(row1.date,1),"20"):
StringHandling.LEFT(row1.date,1)=="0"? StringHandling.EREPLACE(row1.date,StringHandling.LEFT(row1.date,1),"19"):null

I split up the calculation to see where I am going wrong, but I am not sure where my errors are coming from. I separated the formulas and did:

SEE ATTACHED PHOTO

Left1= StringHandling.LEFT(row1.date,1) -- WORKS

Left1PartialCondition = StringHandling.LEFT(row1.date,1)=="1"?"20":null -- DOESN'T WORK (receiving nulls for all)

If someone can give me some input, that would be greatly appreciated as I did look all over community to try and solve this problem.

Thanks in advance!

Re: tMap if condition

cmendels — Fri, 07 Feb 2020 16:22:54 GMT

When you compare strings in Java, you need to use .equals(). So, your condition would be StringHandling.LEFT(row1.date,1).equals("1").

Re: tMap if condition

Anonymous — Fri, 07 Feb 2020 16:48:22 GMT

Hi,

Thank you for your response! So, I tried doing that in the formula and the 19 and 20 is repeating in the date and not just for the 1st left character.

StringHandling.LEFT(row1.date,1).equals("1")? StringHandling.EREPLACE(row1.date,StringHandling.LEFT(row1.date,1),"20"):
StringHandling.LEFT(row1.date,1).equals("0")? StringHandling.EREPLACE(row1.date,StringHandling.LEFT(row1.date,1),"19"):row1.date

Re: tMap if condition

cmendels — Fri, 07 Feb 2020 17:08:02 GMT

EREPLACE replaces all instances of the string, so you might want to do "20"+row1.date1.substring(1).

Re: tMap if condition

Anonymous — Fri, 07 Feb 2020 18:06:16 GMT

Thank you so much!! Got it to work.