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 |
Solved! Go to Solution.
Thank you @phottovy , this is what I was looking for.