Add leading zeros if length = 4

syazwaansyazwaan Member Posts: 3 Newbie
I have a dataset something like this:

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.

Best Answer

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Solution Accepted
    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
    ceaperez

Answers

Sign In or Register to comment.