topic Removing Negative sign from an Integer column in tmap in Talend Studio

Removing Negative sign from an Integer column in tmap

AV2022 — Fri, 15 Nov 2024 21:48:22 GMT

Hello Team,

I have an Input Integer column which are having negative values. My requirement is that i need to eliminate the negative sign from the values.

eg: Input Values

1,-2,3,-4

Expected Output

1.2.3.4

Note: I tried Mathematical.NEG() function in tmap expression builder but it doesn't worked since my input column has Integer as the Datatype. I need the Input and output columns as Integer Data type.

Kindly help me in fixing this issue.

Thanks

Anand

Re: Removing Negative sign from an Integer column in tmap

borke02 — Tue, 16 May 2023 07:17:10 GMT

Hi,

there is an java methode that gives the absolute value of the argument: https://www.tutorialspoint.com/java/number_abs.htm. You can call it in tMap:

Best regards,

Frank

Re: Removing Negative sign from an Integer column in tmap

AV2022 — Tue, 16 May 2023 09:00:59 GMT

Hello Frank,

Thanks alot, your solution worked perfectly fine for me.

Thanks

Anand