Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Add leading zeros if length = 4

I have a dataset something like this:

Image: https://us.v-cdn.net/6030995/uploads/editor/ak/vwon567az7zj.png

I want to add leading 0 if the length of data in column_1 is 4 and return in a new column. So that all data in the new column will be the length of 5.

Expected output:

Thank you.

Find more posts tagged with

AI Studio

Generate Attributes

Accepted answers

BalazsBaranyRM

Hi!

If the data are numeric, you can use Format Numbers with a pattern of 00000. This will convert the numbers to a nominal column with the specified format that includes the leading zero if necessary. This would also work for smaller numbers.

Regards,
Balázs

All comments

Caperez

Hi @syazwaan,

A possible solution is work with a nominal data and logic if rule.

please find attached a simple sample.

Best

comp data.rmp

BalazsBaranyRM