How to use if/else in tMap

JM39 — Sat, 16 Nov 2024 02:53:52 GMT

hello, I've had a look around and can't find the answer to my specific issue.

I have some source data where one of the columns contains a number which can typically be either one, two or three characters. In the output I want all those values to be six characters long. So if the source contains two, I want to add four leading zeros, if the source contains three, I want to add three leading zeros, etc. I'm not sure how to do this?

Re: How to use if/else in tMap

Anonymous — Fri, 27 Mar 2020 01:14:09 GMT

Hi
Take a look at this topic, it provides Java expression to do it.
https://community.talend.com/t5/Design-and-Development/Left-Padding-Integer-With-Zeroes/m-p/75891#M36517

Regards
Shong

topic Re: How to use if/else in tMap in Talend Studio

How to use if/else in tMap

Re: How to use if/else in tMap