Replace value

Hello,
I am reading from a ODBC source and writing to a txt file. I need to transform a column that when the value is "0" to "000" else just write the value. I have tried several functions and case statements with no luck and closet I can come to it is the Lookup Replace function, but it replaces all "0" with "000"

Example of what I would like to see:
114 = 114
930 = 930
0 = 000

Example of what is happening
114 = 114
930 = 93000
0 = 000

Thank you,
Pat

Hi Pat

Thank you for asking such a useful question

It will benefit a lot of users

Since you are replacing just one value the simplest ways it can be done is by using "If Equal to" transformation function.
See attached pictures

Thank you, this worked great and awesome solution!