DSXchange

Hi,
My source values are like :
2
3
10
100

My required target is :
002
003
010
100

Please help me how to pad zeros on left side to an integer using transformer stage.

Thanks,
Eswar

You can use FMT().
Do a search to find out how, based on your requirement.

You may be a bit confused here: integer is a storage format, but you are describing a requirement for displaying the data.

The easiest way to handle this is to convert the integer to a char or varchar before sending it to your display output. The only alternative is to store it in the display format, but that's not efficient for disk or processing.

samsuf2002 wrote:You can use FMT().
Do a search to find out how, based on your requirement.

Fmt() is not available in Parallel jobs.

Provided the target is a string, you can use string functions to pad with leading zeroes. For example: