- Posts: 2
- Thank you received: 0
Adding leading zeros to the field value
12 years 6 months ago #1978
by Melinda
Adding leading zeros to the field value was created by Melinda
Hi there,
Can someone tell me how to put leading 0 in front of field value?
I am new here and I don't know if there is a function for this or not.
Thanks,
Melissa
Can someone tell me how to put leading 0 in front of field value?
I am new here and I don't know if there is a function for this or not.

Thanks,
Melissa
Please Log in or Create an account to join the conversation.
12 years 6 months ago #1980
by admin
Mike
ETL Architect
Replied by admin on topic Re: Adding leading zeros to the field value
This can be easily achieved by using Left pad function.
See attached picture
See attached picture
Mike
ETL Architect
Attachments:
Please Log in or Create an account to join the conversation.
12 years 6 months ago #1981
by Melissa
Replied by Melissa on topic Re: Adding leading zeros to the field value
Thank you very much for the quick response
It is all working as expected.
Melissa
It is all working as expected.
Melissa
Please Log in or Create an account to join the conversation.