transform value into char 4

Hi,

As per your question your values are either of 2 or 3 characters. You can use concatenate function. create a column where you should check length of your character. If it is less than 3 then concatenate it with "00" and if length of character =3 then concatenate it with "0".

check the below expression if this works as per your requirements.

column = if(LEN(your field)<3,CONCATENATE("00",your field),if(LEN(your field)=3,CONCATENATE("0",your field))). Check teh screenshot below.

Thanks,

Atish

Hi Marcox28,

You can also try the function FORMAT.

Column = FORMAT([Column1], "0000")

Best Regards,

Dale