Removing Negative sign from an Integer column in tmap

[AV2022]

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

[borke02 · Accepted solution]

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

[AV2022]

Hello Frank,

Thanks alot, your solution worked perfectly fine for me.

Thanks

Anand