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

Hi @sanketkatoch05 

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

Dynamic Length.yxmd