How to convert the column to 8 digits

[PrathimaV]

Suppose the column name is "X" and has a values "123456", "12345678", "1234"

I would like to set the column values to 8 digits as below

output for column name X values should be set "00123456", "12345677", "00001234"

Please help me on this

Regards,

Prathima

[APrasad_Tri]

Hi @Prathima Venkataram? ,

There are 2 ways to achieve this:

1. using the toolbar Format -> Pad Text with leading characters.

1. use PAD() function to set the values to 8 as shown below.

PAD($col,4,0,left)

Both approaches change the format to String. Convert the Data type to Integer.

I hope this helps.

Best,

Apeksha