Hi All,
I have a scenario in which I have to add leading 0 to make all over length as 9 of the value. If the value is of length 1 then I will add 8 zeros and if the value is of 4 digit lenght then i will add 5 zeros to make it total 9 digits as length.
For Example
Input:
1
2
16
188
1235
Output:
000000001
000000002
000000016
000000188
000001235
Please help
/discussions/pipelines/how-to-add-leading-0-in-a-particular-column-value-to-make-it-fixed-9-digit-numbe/10035