Dynamic Renaming Data From Fields

[sanketkatoch05]

Hi, 

I have a column in my data that contains a set of numbers in a certain format/length. I want Alteryx to find the cell which has a maximum no. of characters first, and then using that as a reference, add preceding zero(s) accordingly.

For reference : 

INPUT

354

4567

2

456789

77

OUTPUT : 

ID

000354

004567

000002

456789

000077

[phottovy · Accepted solution]

Hi @sanketkatoch05 

The attached workflow gives you what are looking for, I believe.

[sanketkatoch05]

Thank you @phottovy , this is what I was looking for.