Visit the official Paxata Documentation portal for all of your doc needs.

Adding Leading Zeros to your data

To add leading zeros, follow this tip.

Assume you have a column which contains numbers.  These numbers all need to be 12 characters in length with leading zeros.
Original ValueDesired Value
22414000000022414
542000000000542
9000000000009


Use a Compute statement.  Concatenate as many zeros as you need for the whole field length, then concatenate it with the Original Number.  From that, take the rightmost 11 characters.

 

RIGHT(CONCATENATE("000000000000",@[email protected] ),12)

 

Sign In or Register to comment.