ETL and Data Integration tools - Modern ETL software for everyone
|
Welcome,
Guest
|
|
TOPIC: Adding leading zeros to the field value
Adding leading zeros to the field value 1 year, 2 months ago #1978
|
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 |
|
|
Re: Adding leading zeros to the field value 1 year, 2 months ago #1980
|
This can be easily achieved by using Left pad function.
See attached picture
Attachments:
|
|
|
Re: Adding leading zeros to the field value 1 year, 2 months ago #1981
|
|
|
|
Testimonials
We were able to validate more data in less time when we started using Advanced ETL Processor
N.Chad
IT Manager
User Login
Our customers
 |
|
|
|
|
 |
